Support 805.461.7300
Our Technology. Your Success.

Remove last word from a field

Description

This command will remove the last word in a field. The word "fieldname" in the command syntax below should be changed to the actual field name you want the last word removed from. 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 fieldname with left(fieldname,rat(" ",alltrim(fieldname))) for occur(" ",alltrim(fieldname))>0

After clicking RUN, the excess data will be stripped from the field of choice, helping clean up the field.

« Back to Commands

I wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
J.S., Newark, OH