Count Characters in a Field

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

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

Post Reply
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Count Characters in a Field

Post by Kristen » Thu Feb 16, 2012 11:05 am

If you want to count the number of characters in a particular field, you can run the following command:

Code: Select all

replace all last with padl(allt(str(len(allt(address)))),3,"0")
index on last descending tag mytag
*In the above command example, the number of characters in the field ADDRESS will be put into the field LAST and it will sort and put the highest number as the top*

Post Reply