community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Regex Formula

I have a cell that contains the following text: Job PSF_AFBIIU. has failed with the completion code 1

I want the regex icon to spit out only: PSF_AFBIIU.

 

In other words I want to parse out "Job" and parse out "has failed with completion code 1".

 

Please note completion code number can differ.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @mcimperman 

 

Here's a solution:

 

REGEX_Replace([Field1], "^Job\s(.*?)\shas\sfail.*","$1")

 

Cheers,

Labels