Is there a way to convert names to initials?

[former_member279138]

I have a name field that I want to show up as just initials in the report.

So

John Smith

Baba Booey

Jane Doe

Would show up as:

JS

BB

JD

Is there a formula I can run to just show the names?

Thanks

[abhilash_kumar · Accepted solution]

HI Kurt,

Try:

(split({database field} , ' ')[1])[1]&(split({database field} , ' ')[2])[1]

-Abhilash

[former_member279138 · Accepted solution]

The first part works but on the second part i get an error

A subscript must be between 1 and the size of the array

I probably should have mentioned that the field normally returns names in the "lastname, first name" format

[former_member279138 · Accepted solution]

Also it's in this format

lastname,firstname

No space after the comma separating the last name and the first name so I'm looking for the first letter after the comma

[abhilash_kumar · Accepted solution]

If the string is separated by a coma, the formula would be:

(split({database field} , ',')[1])[1]&(split({database field} , ',')[2])[1]

-Abhilash

[former_member279138 · Accepted solution]

perfect. thank you