Alteryx Designer

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

Starts with Number

Highlighted
6 - Meteoroid

Hi,

 

I have a string of text that I was to filter for any value that starts with a number i.e 0-9. I'm having trouble getting the syntax of the function correct.

Highlighted
9 - Comet

You can use the RegEx function of regex_match(LEFT([YourField],1),"^\d") in a formula tool and then filter based of the result of the RegEx function.

Highlighted
Alteryx Partner
Just what I needed. Thanks!
Highlighted
8 - Asteroid
69-Ha
68-H3
93,pQ
03?H5

Can you help me with this kind of word formation?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Same formula or:

 

regex_match([field],"\d.*")

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid

Hi,

 

Thanks for replying. I have  numbers too in my column, using this formula it returns the digits too which i don't want. Please below my column.
I need to identify only characters  like '73-HQ' (number + alphabets)

 

LIT99
ADFOP
4050932
4052191
4065666
4073599
69-HQ
73-HQ
1/HQ
73--HQ
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Please create a new post. I'll put the solution there. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid
Labels