Insert comma after last name in the field named First

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Insert comma after last name in the field named First

Post by Eric » Thu Dec 13, 2007 9:38 am

Run the command below when you have a field called first that contains the last name before the first name, without a comma separating the two. The command will change SMITH JOHN to SMITH, JOHN

Running this command will allow the SPECIAL MENU > PARSE NAME feature to work successfully.

Code: Select all

REPLACE first WITH STUFF(first,AT(" ",first),0,",") FOR CHR(32) $ ALLTRIM(first) AND !"," $ first
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply