Filter if contains alphabets

Question

Hello,

I need to filter every record in the field that contains Alphabets in any part.

I attached an example.

Thank you.

Eliminate if contains alphabets.yxmd

Qiu · Answer

@BautistaC888 
I hope this works.

Eliminate if contains alphabets-r1.yxmd

Emmanuel_G · Answer

Hi @BautistaC888 ,

Find attached the way to achieve to that

Eliminate if contains alphabets.yxmd

davidskaife · Answer

Hi @BautistaC888

Here is one way of doing it, using the code

REGEX_CountMatches([text], "[[:alpha:]]" ) =0

:

It counts the number of times a letter appears and filters out records where the count is 0