user16545

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!

Outcomes