Move first word in a field to the end of the field or to another field
The following command will take the first word in a field and move it to the end of the field.
EXAMPLE:
Smith John and Tracy
will change to:
John and Tracy Smith
and
Smith John
will change to
John Smith
|
The command below moves the first word out of the field called First and puts it into the field named Last, and leaves everything else in the First field:
| Replace last with left(first,at(" ",alltrim(first))-1),first with SUBSTR(first,at(" ",ALLT(first))+1) for occur(" ",alltrim(first))>0 |
If you have a comma immediately after the first word, then run this command instead:
| Replace last with left(first,at(" ",alltrim(first))-2),first with SUBSTR(first,at(" ",ALLT(first))+1) for occur(" ",alltrim(first))>0 |
