My target system is having the character limitation at the attribute level and if the value is reaching the limitation then we need to populate the rest of the value in other field and it should be complete.
Input String:- firstname.lastname@example.org;email@example.com;firstname.lastname@example.org;email@example.com;firstname.lastname@example.org;email@example.com
Output / Target attribute Email can accommodate only 30 chars, so in this example Email can hold "firstname.lastname@example.org;email@example.com;n" and we shouldn't be leaving the half email, so Email target attribute should be having only "firstname.lastname@example.org;email@example.com;" and the remaining value in the other field i.e CcEmail.
Could you please help me to achieve this.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
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