Start Free Trial

Alteryx Designer Desktop Discussions

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

Filter Field for only Letters

briankuhlmann
8 - Asteroid

I have a field with Account Numbers. Some are only letters (A-Z), some are only numbers and some are a mix of letters and numbers.

 

Is there a regex_match i could use to identify the accounts with only letters?

 

Right now I tried this in my filter: REGEX_Match([ARMaster], '^[\d\-\.\,]+') 

 

It separates the just numbers accounts but leaves the just letters and mixed accounts together. I am trying isolate the accounts that are strictly A-Z , no numbers.

1 REPLY 1
binu_acs
21 - Polaris

@briankuhlmann 

REGEX_Match([AccountNumber], "^[A-Za-z]+$")
Labels
Top Solution Authors