How to extract table rows based on a column entry (string) which match a pattern?

84 views (last 30 days)
I have table where health column contains has similar values, like '1 Hour Saline', '2 Hour Saline', '2 hour Saline', '3 Hour Saline', '4 Hour Saline'. So far I'm fetching those rows with the following code
mergedTable(mergedTable.health == '1 Hour Saline' | ...
mergedTable.health == '2 Hour Saline' | mergedTable.health == '2 hour Saline' | ...
mergedTable.health == '3 Hours Saline' | mergedTable.health == '4 Hour Saline', :);
Is there an option to write the query using a pattern? I would also prefer the query to be case insensitive. I have attached the sample table for your reference.

Accepted Answer

Cris LaPierre
Cris LaPierre on 14 Oct 2022
Edited: Cris LaPierre on 14 Oct 2022
You can use MATLAB's pattern matching functions (I like contains for this application). The table you shared does not contain any iteration of "Hour Saline" in it, but if it did, something like this should work.
ind = contains(mergedTable.health, "Hour Saline");
T2 = mergedTable(ind, :)

More Answers (0)

Categories

Find more on MATLAB in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!