4 Replies Latest reply: May 19, 2016 11:39 AM by Rob Wunderlich RSS

    Split XML element

    Pavel Bambas

      Hi everybody,

       

      i have problem that i cannot find solution for. I'm trying to split XML element containing text into 3 parts:

      <billing_attributes>Activity=AC32,Costcode=MIMO,Project=999</billing_attributes>

      or

      <billing_attributes>Costcode=ITD340,Project=999,Activity=AC37</billing_attributes>

      or any other mix of Costcode, Project and Activity order in element.


      I need to separate fields Costcode, Project and Activity.

      I tried

      TextBetween(billing_attributes,'Project=',',' or '<') as Project,

      TextBetween(billing_attributes,'Costcode=',',' or '<') as "Cost code",

      TextBetween(billing_attributes,'Activity=',',' or '<') as Activity

      But it didn't work.

       

      Thanks for your advice

      Pavel