Filtering for specific words within a string filed

[aseeland]

Hi all!

I am working with a dataset in which I need to filter for specific records that contain the word 'ice' in a 'Description' column (string field). For example, the 'Description' column might say:

"Cleared snow and ice from parking lot."

Essentially, I am running into the issue where it is pulling words like 'office', 'mice', 'suffice', etc. and I don't want those in the output.

I have a feeling it is a RegEx formula (or I am just severely overthinking this) but if someone could help, it would be greatly appreciated! I can not include the dataset since it is internal only, but if you need more clarification, I can try and create a dummy set!

[ChrisTX]

You could add a Record Id, then use a text to columns tool, delimiter space, split to rows.  then just filter on the new column that will contain full words.

or yes, use RegEx.  send a few examples of words to be searched for.  and a sample input file.

Chris

[rfoster7]

you could just include a space in front and in back of ice in the contains filter (if your actual use case is as simple as your explanation so contains([field],' ice ')

but a regexp that looks for "ice" with a space or non-alphanumeric (like a "." or "," or ";" or "tab" or "line return") before and after ice would be better. 

[binuacs · Accepted solution]

@aseeland 

[aseeland]

Thank you very much!