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

Parsing email addresses into a desired format

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

Regex

Parse

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

This will do what you want.