Rowfilter option in datastore to search for specific pattern in strings

I have a large parquest datastore with several files consisting several rows and four columns. One of these columns have strings of long names. I'd like to extract all of those names that contain a specific pattern, eg:'OS.V' . Normally, i use contains(df.column_C, 'OS.V'), to get the list. But within filter, this throws an error. Is there another way to approach this? Thanks

df.rowfilter = c;  c = (df.column_C=="TUB1.OS.V"); %this gives that specific tag%
%but not this% 
c = contains(df.column_C, 'OS.V'); % I'd like to extract "TUB1.OS.V", "M.TUB2.OS.V",...

[Simon Sigl]

Similar problem here. I would like to specify a filter condition based on a list/set:

aTable = (some tall array);
ids2Filter = ["id1", "id2"];
rf = rowfilter(aTable);
rf2 = rowfilter(ismember(rf.id, ids2Filter)) %ismember does not accept rowfilter

how can this be done?

Answer 1

[Pratyush]

Hi Surya,

I understand that you want to filter rows from your datastore which have a specific pattern for a given column.

Modify your code in the following manner to use contains:

checkPattern = @(str) contains(str, 'OS.V');
c = @(df) checkPattern(df.column_C);

[Surya Kandukuri]

Thank you! I will try that.

[Surya Kandukuri]

Umm.. that doesnt seem to work either...

Error using reconstructAfterSettingImportOptions
Expected RowFilter to be one of these types:

matlab.io.RowFilter

Instead its type was function_handle.