Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Filter if contains alphabets

BautistaC888
8 - Asteroid

Hello,

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

I attached an example.

Thank you.

3 REPLIES 3
DavidSkaife
13 - Pulsar

Hi @BautistaC888 

 

Here is one way of doing it, using the code

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

:

 

DavidSkaife_0-1660810241004.png

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

Emmanuel_G
13 - Pulsar

Hi @BautistaC888 ,

 

Find attached the way to achieve to that

Emmanuel_G_0-1661128761594.png

 

Qiu
21 - Polaris
21 - Polaris

@BautistaC888 
I hope this works.

0822-BautistaC888.PNG

Labels