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:




      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