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.
Solved! Go to 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:
Thanks for your quick responses! Got this working now.