2 Replies Latest reply on Jan 12, 2007 2:35 AM by BKBK

    xml special character

    TommyMTL
      I have an XML formated document from an external apps that I cannot change looking like this:

      <?xml version="1.0" encoding="utf-8" ?>
      <row>
      <charge>3</charge>
      <duration>5</duration>
      <fdomain>1</fdomain>
      <from>"Allibaba"<sip:18002633394@sip.host.ca>;tag=169e3f2c</from>
      <fuser><fuser />
      <start>1167420888.001000</start>
      <tdomain>1</tdomain>
      <to>"John Blaire" <sip:4162595623@localhost></to>
      <tuser>80</tuser>
      </row>

      Reading and outputing this XML is giving me :
      3
      5
      1
      "Allibaba";tag=169e3f2c
      1167420888.001000
      1
      "John Blaire"
      80


      Wen I would like to get:

      3
      5
      1
      "Allibaba" 18002633394
      1167420888.001000
      1
      "John Blaire" 4162595623
      80


      The Parsing is removing <> but in 2 case I need to extract the number followed by <sip: and before @ and remove all the rest

      Is this possible and how?