Support 805.461.7300
Sales
Our Technology. Your Success.

Transfer the last word in a field to another field

Description

This command will remove the last word in a field, and take that word and move it to its own field. The word "FromFieldname" in the command syntax below should be changed to the actual field name you want the last word removed from. Since the last word in FromFieldname will be moved in this command, make sure ToFieldname is changed to the actual name of the field that you will be moving the last word to. This command will not affect records that contain only one word in "fieldname". You can adjust the ">0" clause so the command only acts on records with "n" numbers of spaces. Example, change ">0" to "=3" and the command will only affect records that contain "3" spaces (examples shown below).

The Command At Work

Before Command After Command
Before running command
After running command

The Command

Copy this command, then paste it into the large text area of the command window:

Replace ToFieldname with ltrim(substr(FromFieldname,rat(" ",alltrim(FromFieldname)))), FromFieldname with left(FromFieldname,rat(" ",alltrim(FromFieldname))) for occur(" ",alltrim(FromFieldname))>0

In this command, ToFieldname represents the field that the last word will be filling into. FromFieldname is the field that contains the data that you'll be stripping.

After clicking RUN, the last word in the field will be stripped and placed in its own field.

« Back to Commands

You are a genius and I have no excuse for not thinking of this before calling. Our customer is good with cutting the tops and bottoms for the booklets to get under 16 ounces. Thank you for getting me out of a jam and thank you even more for offering your help with this project! I decided to switch to AccuZIP after speaking with Steve at the Minuteman Show. I was impressed with his idea of customer service and you have totally proven him right.
M.M., Petaluma, CA