Keep First Letter after Comma

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

Help

Preparation

Accepted answers

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')

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')

Thank you! This was what I needed

Let's try:

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

Cheers,

Mark