Regex help? Extracting a User's name from the Description field

[Berto2002]

Hi everyone. Regex is a mystery code with magical properties! But too magical for non-coders :-)

I have emails coming in from an upstream system which I'm picking-up with routing rules and feeding into workflow.

I use this Regex to extract the email address of the user from the Summary and it works fine: (?<=\()(.*?)(?=\))

I then trawled the 'net and came-up with this Regex to extract the contents that follow the "Name:" string: (^Name:\s*\K[^:].*)

But it doesn't work, despite looking like it should in the tester. When I paste the result to the Timeline I get null/blank.

This is the email when we look at Email Source:

[Victor]

@Berto2002 assuming you are using Regex Substring from Utilities, try this:

((?<=Name:\s).*)

Don't ask details, I have none, every time I am looking at REGEX it feels like I have no idea what I am doing. But this is the result with the above output into timeline:

[Frank Reay]

@Victor  you crack me up Victor!!!! I am clearly not alone in this universe when looking at Regex!

[Guest Paul Alexander]

@Berto2002

Have you tried the 'string utilities' options in the BPM nodes for this instead of regex? We use it to find users names in our automated leavers requests. We do a search for a 'known' string 'like "Name:" for instance and then use the  Substring node to extract the info.  Gotta be easier than regex!!

[Berto2002]

Great folks, I have two super suggestions to help! Thank you. I am glad we also all find Regex a mystery lol

[Berto2002]

I went with Victor's Regex and it works. Spread the word about Victor being a genius with Regex :-)

@Paul, your suggestion is in the toolbox for another time. Useful to be about to count to the start of a string and then use that later for something.

[Victor]

@Berto2002 

8 minutes ago, Berto2002 said:

Victor being a genius with Regex

It wasn't me really...