get second word from text field

[RT]

hello everyone.

I need some help with a calc.

i have a field namefirst in this field it is filled with the name DOE JOHN

i need to move the name DOE to namelast field sure this is simple but having a hard time understanding.

Thanks

RT

[efen]

If there is ever only two names in this field (and you want only the first name in the name first field and the last name only in the last name field) then script it [pseudo code] - if this is to be done for all records

Show all records

Goto first record

Set name last field with LeftWords (name first field; 1)

Set name first field with RightWords (name first field; 1)

Loop

Goto next record, exit after last

Set name last field with LeftWords (name first field; 1)

Set name first field with RightWords (name first field; 1)

End loop

[comment]

Another option is to define two stored calculation fields using LeftWords() and RightWords(), respectively. Check your results and if everything looks fine, change the fields to type Text. You can then delete the original field.

[RT]

thank you so much it worked and saved me lots of time and key presses