Convert Alphanumeric to Numeric

Discussion created by user16545 on Jan 13, 2017
Latest reply on Jan 14, 2017 by user16545

Hi all,


we want to count all records in a file with NameFields starting with A, B, C, etc.

We can identify the A's using :      Left (NameField; 1).


We could ofcourse create 26 unstored calculation fields: CountA, CountB, CountC, etc?

It would work but is not very sophisticated.



Can we count them all in one single command, single script step, single variable or field definition?


Thanks in advance!