Parse weird formatted data to XML?

Question

Sample output data is below, it looks something like JSON, but it's not formatted exactly like JSON. So I am wondering, how can I get this data looking like XML, preferably with php?

[{
  action: 'getallregions',
  reply: [{
    regionid: '1',
    name: 'Blue',
    description: 'Research Route',
    color: '508CEB',
    active: 'true',
    parentRegionId: '0',
    parentRegion: ''
  }, {
    regionid: '4',
    name: 'Green',
    description: 'Vet School Route',
    color: '73BE69',
    active: 'true',
    parentRegionId: '0',
    parentRegion: ''
  }, {
    regionid: '10',
    name: 'Purple',
    description: 'Loop route',
    color: '5300B5',
    active: 'true',
    parentRegionId: '0',
    parentRegion: ''
  }]
}]

Here is the data on Pastie.org http://pastie.org/1045154

Here is the data on Pastie.org http://pastie.org/1045154 Thanks for your help. — Ross Waycaster, Jul 15 '10 at 04:37
Ross, you can just edit your question rather than adding that comment. I'll fix this one for you. :) — Matt Ball, Jul 15 '10 at 04:58
Also, the data is basically JSON - it's either incorrectly formatted JSON (because it's incorrectly quoted), or it's just a Javascript object literal. — Matt Ball, Jul 15 '10 at 05:01

score 0 · Answer 1 · edited May 23 '17 at 12:30

0

You might be interested in topic "Is there some way to convert json to xml in PHP?"

Hope, that it helps you.

edited May 23 '17 at 12:30

Community

1
1

answered Jul 15 '10 at 07:45

Eugene

4,352
8
55
79

Narcis Radu · Answer 2 · 2010-07-15T08:04:40.197

0

I don't know if this is what you are looking for, but:

json_decode(preg_replace('/([a-z0-9]+):/i','"$1":',str_replace('\'','"',$data)))

Basically I found a way to make the input valid JSON. The you can convert the object to xml using the XML_Serializer.

edited Jul 15 '10 at 08:04

answered Jul 15 '10 at 07:52

Narcis Radu

2,519
22
33

Parse weird formatted data to XML?

2 Answers2