Converting name from last name first to first name first 1

[thebobman]

I am working with a data field of people names that are stored last name first ie Public John Q

I need to convert it John Q Public

Any suggestions

Thanks

 

[goranm]

Hi !

Create a formula:

StringVar NewString;
NumberVar pos := Instr({YourName}, ' ');

New_String := mid({YourName},pos +1) + ' ' + mid({YourName},1,pos -1)

And there you will have what you want (I hope).

/Goran