Count Characters in a Field

[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*