I have imported data from an Excel File. The file has one field that has both first name and last name. I was able to get my script to copy the last name to another field but I can't figure out what step to use to clear the last name from the original field. My table has three fields one for last one for first and one for account My script looks like this:
Set Variable [$lastname; Value:LeftWords (Table::Firstname; 1)
Set Field [Table::LastName; $lastname]
Set Selection [Start Position: LeftWords ( Table::Firstname ; 1)
What goes next? to clear the selction?