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.
Substring of unknown length
Moderators: chulett, rschirm, roy