Parsing email addresses into a desired format

[arundaka02]

Hi everyone

I want to parse email addresses from an output of a survey responses. The format of the email addresses are as follows:

Essentially I'd like the desired output to:

• Full name displayed in one column (first name, middle initial and surname)
• First letter of first and surname capitalised and the middle initial capitalised too
• Keep the middle initial, where applicable

A similar thread can be found here where RegEx is used to resolve the issue.

Can anyone help?

Thanks

KA

[paulfound]

Hi @arundaka02 

This will do what you want.

I used RegEx and TitleCase Funtion.

Let me know how you get on.

[Jonathan-Sherman · Accepted solution]

Hi @arundaka02,

This is possible using Regex as you said!

Personally I would create three expressions in the formula tool:

It could be done in one, but for simplicity I always find it's best to break my expressions down!

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[arundaka02]

Thank you, @Jonathan-Sherman !