Split String based on the char length

RAtirajyam — Tue, 28 Feb 2017 16:14:17 GMT

Hi,
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.

For Ex:-

Input String:- abc@gmail.com;acf@gmail.com;nhju@gmail.com;123@gmail.com;989@gmail.com;asdads@gmail.com
Output / Target attribute Email can accommodate only 30 chars, so in this example Email can hold "abc@gmail.com;acf@gmail.com;n" and we shouldn't be leaving the half email, so Email target attribute should be having only "abc@gmail.com;acf@gmail.com;" and the remaining value in the other field i.e CcEmail.
Could you please help me to achieve this.

Re: Split String based on the char length

Anonymous — Wed, 01 Mar 2017 07:36:09 GMT

Hi,
Here is a TalendHelpCenter:tSplitRow which is used to split one input row into several output rows. Could you please take a look at this component to see if it is what you are looking for?
Best regards
Sabrina

topic Re: Split String based on the char length in Talend Studio

Split String based on the char length

Re: Split String based on the char length