Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to generate ASCII values for an alphabetic sequence

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

Labels (2)
1 Reply
Anonymous
Not applicable
Author

hi,
 
have a llk at tExtractRegexFields or tExtractDelimitedFields
https://help.talend.com/search/all?query=tExtractDelimitedFields
https://help.talend.com/search/all?query=tExtractRegexFields

need some knowledge about regex

regards
laurent