Substring of unknown length

sam334 · Post by **sam334** » Tue Dec 01, 2015 1:33 pm

Hi all, Need a help in Substring of a value.

We have a column ID:- 1111111111AB01, 2222222222ABCD02, 2121212121ADBC01.

So its a 10 digits length of ID then character. I have (11,4) in transformer to get the character such as AB,ABCD,ADBC.

Now issue is, ID length may change, it could be 11 digit or could be 10 digit. So (11,4) wont work. Any other advice how we could achieve this..

Primary goal is to get the character (AB/ABCD/ADBC) out from the string.

chulett · Post by **chulett** » Tue Dec 01, 2015 1:39 pm

Sounds like the "double convert" would work for you. One such example is here.

sam334 · Post by **sam334** » Tue Dec 01, 2015 2:42 pm

Perfect. Thanks a lot Craig.