Regex Formula

[mcimperman]

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.

[Thableaus · Accepted solution]

Hi @mcimperman 

Here's a solution:

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

Cheers,