RegEx

[KA]

Can anyone help with this RegEx? I am trying to separate the sender name and sender email into two different columns. 

[KA]

Correct File

[ShankerV]

Hi @KA 

Please let me which column you are tryin to split and at which step.

The workflow is huge and couldn't get which place you need to do implement Regex.

Many thanks

Shanker V

[ShankerV]

Hi @KA 

Do you need to split the sender name and email address here.

Many thanks

Shanker V

[KA]

Yes, it is that column 

[ShankerV · Accepted solution]

@KA 

Please check and let me know if this helps.

Regex:

"(.*)"<(.*)>

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[ShankerV]

@KA 

I have gone through the entire data set, where in row no 11, the input is as below.

The output shows as null and null.

However I believe you need the Sender name as Empty and Email address to be populated.

You can use this method to overcome this problem with the huge dataset where the name is missing in few data's.

Add Formula tool, 

And the same regex,

Then the desired output is as below.

Hope your issue is resolved for huge dataset. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[ShankerV]

@KA 

Formula tool:

if (StartsWith([Sender],'<'))
then '" "'+[Sender]
else [Sender]
endif

Shanker V