Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
RAtirajyam
Contributor
Contributor

Split String based on the char length

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.

Labels (2)
1 Reply
Anonymous
Not applicable

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