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

[Manjari]

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.

[ydmuley]

Hello @Manjari 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/

[Manjari]

Hi @ydmuley,

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

[ydmuley · Accepted solution]

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

[Manjari]

Hi @ydmuley,

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

[ydmuley]

@Manjari I am glad that it worked!