Portal XML output to something useable?

[SuperMacGuy]

When I am getting XML out of my database layout, the data that comes from a portal is not formatted very usefully. That is, I can get the regular file data just fine, but portal info comes out as each column data, not as 1 row in a record, with each part of data with a label. I get something like this:

<myrelationship.column1>

<data>10 </data>

<data>11 </data>

<data>12 </data>

</myrelationship.column1>

<myrelationship.column2>

<data>a </data>

<data>b </data>

<data>c </data>

</myrelationship.column2>

How do I format this into something that resembles the portal table that I started with in FMP? (I am using a Mac and don't have any java or programming experience, so examples would be very helpful for me.)

Thanks!!

Chris