Hello,
i have a requirement where, my source is sending some long description and i need to map it to different fileds...
so say my source sends some thing like 260 characters...i need the same to be split as 140 in target field A, 40 in target field B, 40 in c and 40 in D.
but this is not my concern, this is taken care of..
Now, the question is...if say from 137th character the word "telephone" starts...i do not want my target field to get truncated with value upto 140 character or ....tele. i want XI to apply some logic and take it till 144th character, i.e end of word telephone and then B would have from 145th character to 180th character and same way for other fields...
Is the above possible, and if yes, then how?
Thanks,
Vishal