String Value Formating

[nicouek]

Hello All,

I would like to ask if you could help me with this problem. Thank you.

My field [name] shows value as: 'FIRSTN LASTN' --> 'JOHN DO'

Is there a way to for me to transform all the values in the field to show a 'COMMA' (,) between FIRSTN and LASTN

=FIRSTN, LASTN (JOHN, DO)

Thank you.

[BrunPierre · Accepted solution]

Perhaps?

SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2) as FullName;

or

=SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2)

[nicouek]

Dear BrunPierre,

Never mind! your solution is on point (CORRECT), had to put SPACE between the SINGLE QUOTES ('' vs ' ')

=SubField( [name], '  ', 1) & ', ' & SubField( [name], '  ', 2

It works!!!

Thank you