Page 1 of 1

Count Characters in a Field

Posted: Thu Feb 16, 2012 11:05 am
by Kristen
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*