Filter out data

[mmustkee]

Hi Team,

I have a table below. I want to filter out all blanks and the all the words which starts with "CS" "SR" "WS". Please help.

CST

SRT

PST

KT

SR

SR/TRS

SRS

SR/SRT

WSR

WS/ws

WRS

[Emil_Kos · Accepted solution]

Hi @mmustkee,

This is the formula that you should put in the filter tool:

!IsEmpty([Field1]) AND Left([Field1], 2) NOT IN ('CS','SR','WS')

[vizAlter · Accepted solution]

Hi @mmustkee — Try this solution:

Use below RegEx expression in a Filter tool (it will exclude the Null cells as well):

!REGEX_Match([Field1], "^(CS|SR|WS|(?!\w)).*")

Please mark this solved if it helps.

[mmustkee]

Hi,

The first filter worked for me. Second filter took out other data too.

Thanks a lot for your response.

[vizAlter]

@mmustkee — Here is a quick explanation of my RegEx:

^ Match must occur at start of string
() capturing group - the regex inside the parenthesis must be matched and the match create a capturing group
| OR operator
?! Not to match (is for negative look ahead)
\w  Any word character [a-zA-Z0-9_]
. Matches any character except newline \n
* Match zero or more of the pattern defined before it

Please mark this solved if it helps!