Re constructing XML file
I have an XML file below:-
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<CourseEvents>
<Code>VEN01</Code>
<VenueDescription>Crazy Johns - Internal</VenueDescription>
<ReferenceNo>50</ReferenceNo>
<Address1>1233 Crazy Drive</Address1>
<Address2 />
<Address3 />
<Suburb>Sth. Melb.</Suburb>
<Postcode>3030</Postcode>
<State>Victoria</State>
<firstday>Wednesday, 22-March-2006</firstday>
<lastday>Tuesday, 28-March-2006</lastday>
<CourseCode>PHS101</CourseCode>
<Description>Physics</Description>
<StartTime>2006-03-28T09:00:00.0000000+10:00</StartTime>
<FinishTime>2006-03-28T18:00:00.0000000+10:00</FinishTime>
<InternalEvent>true</InternalEvent>
</CourseEvents>
</NewDataSet>
How can i re-write it to something like
<?xml version="1.0" standalone="yes" ?>
- <NewDataSet>
- <CourseEvents VenueDescription="Crazy Johns - Internal" ReferenceNo="50">
- <Course CourseCode="PHS101" Description="Physics">
- <Day firstday="Wednesday, 22-March-2006" lastday="Tuesday, 28-March-2006"
Code="VEN01">
- <Time StartTime="2006-03-28T09:00:00.0000000+10:00"
FinishTime="2006-03-28T18:00:00.0000000+10:00">
<Address1 Suburb="" Postcode="" State="" />
<Address2 Suburb="" Postcode="" State="" />
<Address3 Suburb="" Postcode="" State="" />
</Time>
</Day>
</Course>
</CourseEvents>
</NewDataSet>
Any ideas?
Thanks
|