I want to put one xml record in one row and so on...
sample two records are here.
<?xml version="1.0"?>
<Object>
<Header>
<XCOMVers>V1.0</XCOMVers>
<REPORT>XXXXX</REPORT>
<CODE>002</CODE>
</Header>
<IssueCard>
<Record>
<L>CAR SYSTEM -SSSSS -</L>
<L> CODE: 202</L>
<L>---</L>
<L>Message:</L>
<L>:21:XXXXXXXX</L>
<L>:103B:/1213-XX736472-567GH0</L>
<L>---</L>
<L>Confirm:</L>
</Record>
</IssueCard>
</Object>
<?xml version="1.0"?>
<Object>
<Header>
<XCOMVers>V1.0</XCOMVers>
<REPORT>XXXXX</REPORT>
<CODE>002</CODE>
</Header>
<IssueCard>
<Record>
<L>CAR SYSTEM -SSSSS -</L>
<L> CODE: 202</L>
<L>---</L>
<L>Message:</L>
<L>:21:XXXXXXXX</L>
<L>:103B:/1213-XX736472-567GH0</L>
<L>---</L>
<L>Confirm:</L>
</Record>
</IssueCard>
</Object>
I want output as :
<?xml version="1.0"?><Object> <Header> <XCOMVers>V1.0</XCOMVers> <REPORT>XXXXX</REPORT> <CODE>002</CODE> </Header> <IssueCard> <Record> <L>CAR SYSTEM -SSSSS -</L> <L> CODE: 202</L> <L>---</L> <L>Message:</L> <L>:21:XXXXXXXX</L> <L>:103B:/1213-XX736472-567GH0</L> <L>---</L> <L>Confirm:</L> </Record> </IssueCard></Object>
<?xml version="1.0"?><Object> <Header> <XCOMVers>V1.0</XCOMVers> <REPORT>XXXXX</REPORT> <CODE>002</CODE> </Header> <IssueCard> <Record> <L>CAR SYSTEM -SSSSS -</L> <L> CODE: 202</L> <L>---</L> <L>Message:</L> <L>:21:XXXXXXXX</L> <L>:103B:/1213-XX736472-567GH0</L> <L>---</L> <L>Confirm:</L> </Record> </IssueCard></Object>
Please guys need help.