I am new to Talend and fairly new to anything JAVA/scripting related so would really appreciate your help.
I have a range of telephone numbers which I would like to clean up using the tMap component.
I have successfully managed to remove spaces etc, however in this field, my company has stored a lot of telephone extensions so typically the number would look like this:
I would like to remove everything after the 'x' and then store the value after the 'x' in a variable and then populate the another column with the data after the 'x' so that the telephone extension is not lost when we migrate our systems next year.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables