Filtering by Partial String Criteria

Question

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 Answer

Hi @logans

I have uploaded a sample WF.

Hope this helps.

DataNath · Accepted Answer

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: