topic String Value Formating in App Development

String Value Formating

nicouek — Thu, 27 Jul 2023 20:09:14 GMT

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 — Thu, 27 Jul 2023 21:26:54 GMT

Perhaps?

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

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

nicouek — Thu, 27 Jul 2023 23:04:08 GMT

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