Alteryx designer Discussions

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

Requesting help in building a Regex to match "ZYFCSFS674FF-1228837741-296"

Highlighted
Asteroid

Hi All,

 

Requesting help in building a regex to match "ZYFCSFS674FF-1228837741-296"

My Regex tool has "[a-zA-Z0-9]*[-][0-9]*[-][0-9]*" which does not work.

Highlighted
Quasar
Quasar

Hello @Manjari_T Looks like the expression that you have for RegEx is just fine.

 

You can use this website to experiment/test your parsing. Once you find the formula you can directly add to the RegEx tool.

 

https://regex101.com/

Highlighted
Asteroid

Hi @ydmuley,

 

The Regex works fine in the Regex tester, but fails in the alteryx Regex tool. I am not not why.

 

Quasar
Quasar

What output method have you selected? @Manjari_T Not sure if you tried Tokenize

Highlighted
Asteroid

Hi @ydmuley,

 

Tokenize option worked like a charm, thank you so much:)

Highlighted
Quasar
Quasar

@Manjari_T I am glad that it worked!

Labels