topic Re: how to generate ASCII values for an alphabetic sequence in Talend Studio

how to generate ASCII values for an alphabetic sequence

Anonymous — Thu, 03 Sep 2015 11:53:50 GMT

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

Re: how to generate ASCII values for an alphabetic sequence

Anonymous — Tue, 08 Sep 2015 05:18:53 GMT

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

Best regards
Shong

Re: how to generate ASCII values for an alphabetic sequence

Anonymous — Thu, 10 Sep 2015 13:09:17 GMT

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

Re: how to generate ASCII values for an alphabetic sequence

Anonymous — Tue, 15 Sep 2015 13:48:14 GMT

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

Best regards
Shong