Manipulate data in a string

[khan82]

I have a field that contains a name but its in the format last name first, first name last.

the last name and first name is seperated by a ;

how can i write a formula to display first name first and last name second? do i use a mid formula?

Thanks

 

[pmax9999]

Try:

Split({Table.Field},';')[2] + ' ' + Split({Table.Field},';')[1]

Cheers
Pete

 

[khan82]

thanks man! works like a charm.