Support 805.461.7300
Sales
Our Technology. Your Success.

Insert a comma between last and first names in FIRST field

Description

This command is used to set up your FIRST field for the Parse feature of AccuZIP6, which takes first and last names that appear in a single field (in this case, the field called FIRST) and separates the data into its proper fields (keeping first names in FIRST and moving last names to LAST).

Use this command when your last name appears before the first name, with a space separating the fields. This command will replace the space in between the fields with a comma, which will tell AccuZIP (during the Parse feature) that the last name comes before the first name in the FIRST field.

The Command At Work

Before Command Before Command
Before running the Command
After running the Command

The Command

REPLACE first WITH STUFF(first,AT(" ",first),0,",") FOR CHR(32) $ ALLTRIM(first) AND !"," $ first

In this command, FIRST represents the field that contains the last and first names.

After clicking RUN, the space that separates the last name from the first will be replaced with a comma, so the Parse feature [under the Special menu] will work perfectly.

« Back to Commands

I Just wanted to let you know we are in the Postal Fort Worth Texas Division and I received a call from someone in their office today wanting to ask me some questions. He asked if I understood about the changes with the move update starting for this month, then he asked me what software we were using. I explained to him that we have been using AccuZIP Software for the last 20 years and I thought you were the #1 in the United States. I told him that you were the only software displayed in the Postal Section of the Smithsonian Institute. He asked me if I had to manually change the updated addresses and I told him no that the Software did it for us and I could print a report showing the old address and the new address. He told me out of 32,000 names that were updated only 3 were wrong and he just wanted to call me to see what Software we were using. Thanks for such good software and support from your company over the past 20 years.
C.K., Wichita Falls, TX