Help with Regex Parsing

[schenkelpat]

Hello,

New to Atleryx.  Trying to parse a field to get a desired output.  Currently, i have Field1 that has a Project ID, delimiters, & a project title.  I want just the project title.  Can anyone give me an assist or direct me to some other resources?

Field1	Desired Output
328;#Charge	Charge
1236;#Capsule Passer (Football)	Capsule Passer (Football)

Thanks in Advance!

[Thableaus · Accepted solution]

Hi @schenkelpat 

This should work:

Add a Formula Tool:

REGEX_Replace([Field1], "\d+;#", "")

By the way, welcome to Alteryx and the Community. Hope you enjoy the Thrill of Solving!

Cheers,

[schenkelpat]

Thank you @Thableaus !  Worked perfectly! I really appreciate the help!