how to generate ASCII values for an alphabetic sequence

[Anonymous]

Hi,
The sequence goes like A, B, C ...... Z, AA, AB, AC ..... AZ, BA, BB, BC.... BZ, CA, CB, CC....CZ, DA......ZA, ZB....ZZ, AAA, AAB, AAC....AAZ, ABA, ABB... AZZ, BAA, BAB....ZZZ
I want output as1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20........27,28,29,,,,,,,,,,,,,,,,,,,,,,,,,,,
using talend component .
Any suggestions thanks in Advance
Regards
VK

[Anonymous]

Hi
You can call the system function Numeric.sequence("s1",1,1) to generate a sequence number for each row. 

Best regards
Shong

[Anonymous]

hi shong,
thanks for your reply
but if my input is A,B,C,D,AA,AB,AZ,BA,BF,BZ,ZZ,AAA,ZAB,ZZZ
THEN HOW COULD I USE  Numeric.sequence("s1",1,1)  


THANKS
VK

[Anonymous]

Hi
Add one column in the output table of tMap, and set its expression as:
Numeric.sequence("s1",1,1) 

Best regards
Shong