I have a data coming from database out of which one field value is a:1|b:2| :3.......This Data with pipe symbols and : delimiter is dynamic.Now,this data has to be split into below XML structure:
This kind of splitting is for one field from database.Like this I have 2 more fields which has to split like above
Once i achieve this XML format,I need to combine these xml's and map with final data based on primary key of database.
Can you please help me Adam Arrowsmith with groovy scripting?
I have referred to https://community.boomi.com/message/14755?commentID=14755#comment-14755 link and need some inputs on my requirement