AnsweredAssumed Answered

Need help with converting multi select csv data into separate elements in the xml request

Question asked by deepak.agrawal on May 28, 2015
Latest reply on Aug 22, 2017 by dheeraj.mishra@thermofisher.com

I have source data stored as semi colon separated which is shown below.
<CLINICAL_AGE_GROUPS>
    <CLINICAL_AGE_GROUP>Adults;Children</CLINICAL_AGE_GROUP>
  </CLINICAL_AGE_GROUPS>

 

I need to be able to generate output which is shown below.
<CLINICAL_AGE_GROUPS>
    <CLINICAL_AGE_GROUP>Adults</CLINICAL_AGE_GROUP>
    <CLINICAL_AGE_GROUP>Children</CLINICAL_AGE_GROUP>
  </CLINICAL_AGE_GROUPS>

 

Note that the number of data points is not limited to 2 but could vary depending on selection in the source application.

Outcomes