Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,...

Anonymous — Mon, 29 Oct 2018 21:42:48 GMT

I wanted to use a 3 digit alphanumeric sequence like :

A01,A02,..A99,B01,B02,....,Z99,AA1,AA2,...AB1,AB2,...ZZ9.

How to achieve this is talend?

Re: Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,...

fdenis — Tue, 30 Oct 2018 14:08:42 GMT

it's not just a sequence like hexa because you have your own logical.
can you have 001 or 000
can you have ZZZ
can you have A1A after A19

so you have to write your logical first then convert to an algorithme then to code it.
in talend you have to code in java.
If you want to retrieve it from a db you have to code it into db language.
the last solution is to fill a file with all possibilities (it's sometime quickest).

topic Re: Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,... in Talend Studio

Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,...

Re: Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,...