ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
14 - Magnetar

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
Top Solution Authors