Keep First Letter after Comma

[GustavoP]

Hello! Reaching out for help. I have the following set of data:

Name

Smith,John

Lopez,Mark

I need to change into:

J. Smith

M. Lopez

Suggestions? Thank you

[jrgo · Accepted solution]

This formula should get you what you need assuming that ALL your records are formatted exactly the same as your example.

REGEX_REPLACE([Name], '^(.+?),(\w).*$', '$2.$1')

[GustavoP]

Thank you! This was what I needed

[MarqueeCrew]

Hey @GustavoP ,

Let's try:

Regex_Replace([Name],"(.*?),\s*(\w).*",'$2. $1')

Cheers,

Mark