Using Regex to Parse

[cchannyyy]

Hi Alteryx Community,

I want to parse out this line item Mobile Medium Rectangle_TO_DISP_MOB_300x250_N/A_01/11/2019_01/11/2019_3rd_PKG_NA_PX6341 using REGEX. I'm looking to capture only PX6341 into a new column and was wondering what the regex syntax would be?

Thanks!

[fmvizcaino · Accepted solution]

Hi @cchannyyy ,

You can achieve that by using the parse method and the expression ([^_]+$)

Let me know if that works for you.

Best,

Fernando Vizcaino