Format name/Nameswitch

[SarahMS]

I have a name field that is formated like Smith, John D. Can someone tell me what the best way to reformat it to John D. Smith would be? I could drop back out to sql and do it, but if I can, I'd rather do it in crystal.

Crystal 8, sql 2000.

 

[chelseatech]

numbervar i:=instr({table.name},", "

if i=0 then // no comma so can't split it
{table.name}
else
mid({table.name},i+2) & left({table.name),i-1)

I'm assumning that the format is always Surname, firstname
(i.e. there is a space after the comma that we don't want)
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm