Support 805.461.7300
Our Technology. Your Success.

Remove the Last Number from a field


This command will remove the last word in a field only if the data in the field named "fieldname" ends with a number (see examples, below). 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 effect records that contain only one word in "fieldname".

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 and asc(right(alltrim(fieldname),1))>=48 and asc(right(alltrim(fieldname),1))<=57

After clicking RUN, the excess data (that ends with a number) will be stripped from the field of choice, helping clean up the field.

« Back to Commands

I just wanted to take a moment and let you know what an asset Donna Tackett is to your organization. I can not tell you how many times she has helped me understand direct mail as well as the software. She has definitely become my “go to “ person when it comes to doing a mailing. Always professional and personable, I can’t brag about her enough.
B.S., Fayetteville, NC