Alteryx Designer Desktop Discussions

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

Getting all numbers and One letter with REGEX

vnzboy218
5 - Atom

I have a column that has both numbers and text. I need to get all the numbers ( I could get that with "^\d+$" ) but I also need to include a word that starts with the letter C. Hence I need all numbers and this one row that has a word starting with C. 

Help!

 

thanks-

1 REPLY 1
DiganP
Alteryx Alumni (Retired)

@vnzboy218 Try this in the regex, parse formula. Is this what you are looking for?

 

(^[C].*|\d+$)

Regex.PNG 

Digan
Alteryx
Labels