Re-arranging name fields
Hi,
I need help in re-organising name field, which is presently in lastname,
firstname followed by employee id format into firstname lastname format.
For eg, i have
'Was,Yu Wah 1320 0'
I need this to be re-arranged as
'Yu Wah Was'
The problem is not all the employees have two first names. So , there
are cases where the name is like
'Was,Yu 1340 0 '
and this is to be arranged as
'Yu Was'
Is this possible?
Regards
Govind.
|