how to convert A-Z to C character and 0-9 to N character

rsmohankumar253 · Post by **rsmohankumar253** » Sun Mar 26, 2017 10:27 am

Hi,

I want the logic to convert the alphabets a-z to the character 'C', numbers 0-1 to character 'N' and special characters to 'S' character to find the data type distribution. can you please let me know how can we convert the character in IBM datastage 9.1.

Example

value: Hello World 2017 !!!

converted value: CCCCC CCCCC NNNN SSS

ray.wurlod · Post by **ray.wurlod** » Sun Mar 26, 2017 3:50 pm

Use Information Analyzer, which does all this out of the box.

Otherwise use a long Convert() function (with 52 'C' and ten 'N' characters) in DataStage (in Transformer stage).

Code: Select all

Convert('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghiklmnopqrstuvwxyz0123456789', 'CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCNNNNNNNNNN', InLink.TheString)

(Technically you don't have to convert the first "C" character. But I believe that the intent is clearer if you do.)