Swap two strings separated by delimiter

[narband2778]

Hi guys,

I have a Field (Full Name).

All the names in that field are (first name, last name).

My requirement is to swap first and last name. For ex (John, Bell) to (Bell, John).

How to do it?

Waiting for your replays.

Thanks In Advance,

Naresh

[hic · Accepted solution]

For example

     Subfield(Name,',',2) & ' ' & Subfield(Name,',',1) as Name

HIC

[rustyfishbones]

try

SUBFIELD([Full Name],',',-1)& ' ' & SUBFIELD([Full Name],',',1)  AS Name