Filtering by Partial String Criteria

[logans]

Hi,

I want to filter rows from a file that contain certain string criteria within a cell.

For example, I have the below table. I want to filter the Status column and only return the row that has "Unmatched" in this column. After scanning the forums I have tried the following iterations, but none have worked.

[Status] in("Unmatched")

Contains("Unmatched",[Status])

EndsWith("Unmatched", [Status])

FindString("Unmatched",[Settle Status])

Status

(12/12/2022)Unmatched as per agent

(12/12/2022)Matched as per agent

Brand new user so hopefully this is a simple problem. Thanks in advance.

[PanPP · Accepted solution]

Hi @logans 

I have uploaded a sample WF. 

Hope this helps.

[DataNath · Accepted solution]

Hey @logans, you were absolutely right to be using the Contains() function! The only issue was that you had the arguments the wrong way round. The function is Contains([Field], <Target>) so would be like this:

[logans]

Thanks for your quick responses! Got this working now.