Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps?
SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2) as FullName;
or
=SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2)
Perhaps?
SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2) as FullName;
or
=SubField( [name], ' ', 1) & ', ' & SubField( [name], ' ', 2)
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