Hi, I just started with Talend and am learning a lot. But I have an issue I can't resolve and haven't found a solution to yet.
I have a table with combined info. It consists of postal code and address and I want it split.Example: "6093 EA Heythuysen". It has to split in "6093 EA" and "Heythuysen".
Via tMap I have added the column twice to the right side.
In the first I did a stringhandling.LEFT on the first 7 positions and this works. I get the 6093EA.
On the other output I can't use a stringhandling.RIGHT because I have different values with different lengths.
I tried substring(7) but then I get a string index out of range error.
