How to convert XML to CSV?

[saurabh9gupta]

Hello All,

I am developing a project in which i have to feed the data in the form of CSV. But the data that I am getting is in XML format.

I need help as to how we convert an XML file into CSV.

Please reply asap!

[peochei]

Certainly it depends on the format of XML file. You haven't specified anything about how the XML file would look like.

If the format is the same in whole XML file you can read first group of elements, build appropriate columns and continue reading the file storing data in some dataset structure.

While reading consider using XmlReader which is fast.

It would be harder if XML contains hierarchical data because you have to present this in some not-standard way, ex:
a) by indenting nested elements of some offset
b) by extending root elements of new columns with that data

It will be simpler if you give us a sample of XML file or at least describe its format.

[saurabh9gupta]

Please find the xml below

[saurabh9gupta]

The Xml looks


<Document xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" xmlns="urn:iso: std:iso:20022:t ech:xsd:pacs.00 8.001.01">
<pacs.008.001.0 1>
<GrpHdr>
<MsgId>MsgId1 </MsgId>
<CreDtTm>xxxx-some value-xxxx</CreDtTm>
<NbOfTxs>NbOfTx s1</NbOfTxs>
<TtlIntrBkSttlm Amt Ccy="xxxx-some value-xxxx">0</TtlIntrBkSttlmA mt>
<IntrBkSttlmDt> xxxx-some value-xxxx</IntrBkSttlmDt>
<SttlmInf>
<SttlmMtd>xxx x-some value-xxxx</SttlmMtd>
<ClrSys>
<Prtry>xxxx-some value-xxxx</Prtry>
</ClrSys>
</SttlmInf>
<InstgAgt>
<FinInstnId>
<BIC>xxxx-some value-xxxx</BIC>
</FinInstnId>
</InstgAgt>
<InstdAgt>
<FinInstnId />
</InstdAgt>
</GrpHdr>
<CdtTrfTxInf>
<PmtId>
<InstrId>xxxx-some value-xxxx</InstrId>
<EndToEndId>End ToEndId1</EndToEndId>
<TxId>TxId1</TxId>
</PmtId>
<PmtTpInf>
<SvcLvl>
<Cd>xxxx-some value-xxxx</Cd>
</SvcLvl>
<LclInstrm>
<Prtry>xxxx-some value-xxxx</Prtry>
</LclInstrm>
</PmtTpInf>
<IntrBkSttlmA mt Ccy="xxxx-some value-xxxx">0</IntrBkSttlmAmt>
<AccptncDtTm>xx xx-some value-xxxx</AccptncDtTm>
<InstdAmt Ccy="xxxx-some value-xxxx">0</InstdAmt>
<XchgRate>1</XchgRate>
<ChrgBr>xxxx-some value-xxxx</ChrgBr>
<ChrgsInf>
<ChrgsAmt Ccy="xxxx-some value-xxxxR">0</ChrgsAmt>
<ChrgsPty>
<FinInstnId />
</ChrgsPty>
</ChrgsInf>
<InstgAgt>
<FinInstnId />
</InstgAgt>
<UltmtDbtr>
<Nm>Nm1</Nm>
</UltmtDbtr>
<Dbtr>
<Nm>Nm1</Nm>
<PstlAdr>
<AdrLine>AdrLin e1</AdrLine>
<AdrLine>AdrLin e2</AdrLine>
<Ctry>Ctry1</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BIC>BIC1</BIC>
<IBEI>IBEI1</IBEI>
<BEI>BEI1</BEI>
<EANGLN>EANGLN1 </EANGLN>
<USCHU>USCHU1 </USCHU>
<DUNS>DUNS1</DUNS>
<BkPtyId>xxxx-some value-xxxx</BkPtyId>
<TaxIdNb>xxxx-some value-xxxx</TaxIdNb>
<PrtryId>
<Id>Id1</Id>
<Issr>Issr1</Issr>
</PrtryId>
</OrgId>
</Id>
<CtryOfRes>Ctry OfRes1</CtryOfRes>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>IBAN1</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId />
</DbtrAgt>
<CdtrAgt>
<FinInstnId />
</CdtrAgt>
<Cdtr>
<Nm>Nm1</Nm>
<CtryOfRes>Ctry OfRes1</CtryOfRes>
</Cdtr>
<CdtrAcct>
<Id />
</CdtrAcct>
<UltmtCdtr>
<Nm>Nm1</Nm>
</UltmtCdtr>
<InstrForCdtrAg t>
<Cd>CHQB</Cd>
<InstrInf>Instr Inf1</InstrInf>
</InstrForCdtrAgt >
<Purp>
<Cd>Cd1</Cd>
</Purp>
<RgltryRptg>
<DbtCdtRptgInd> xxxx-some value-xxxx</DbtCdtRptgInd>
<Authrty>
<AuthrtyNm>Auth rtyNm1</AuthrtyNm>
<AuthrtyCtry>Au thrtyCtry1</AuthrtyCtry>
</Authrty>
<RgltryDtls>
<Cd>Cd1</Cd>
<Amt Ccy="xxxx-some value-xxxx">0</Amt>
<Inf>Inf1</Inf>
</RgltryDtls>
</RgltryRptg>
<RltdRmtInf>
<RmtId>RmtId1 </RmtId>
<RmtLctnMtd>FAX I</RmtLctnMtd>
<RmtLctnElctrnc Adr>RmtLctnElct rncAdr1</RmtLctnElctrncA dr>
<RmtLctnPstlAdr >
<Nm>Nm1</Nm>
<Adr>
<AdrTp>ADDR</AdrTp>
<AdrLine>AdrLin e1</AdrLine>
<AdrLine>AdrLin e2</AdrLine>
<AdrLine>AdrLin e3</AdrLine>
<AdrLine>AdrLin e4</AdrLine>
<AdrLine>AdrLin e5</AdrLine>
<StrtNm>StrtNm1 </StrtNm>
<BldgNb>BldgNb1 </BldgNb>
<PstCd>PstCd1 </PstCd>
<TwnNm>TwnNm1 </TwnNm>
<CtrySubDvsn>Ct rySubDvsn1</CtrySubDvsn>
<Ctry>Ctry1</Ctry>
</Adr>
</RmtLctnPstlAdr>
</RltdRmtInf>
<RmtInf>
<Ustrd>Ustrd1 </Ustrd>
<Ustrd>Ustrd2 </Ustrd>
<Ustrd>Ustrd3 </Ustrd>
</RmtInf>
</CdtTrfTxInf>
<CdtTrfTxInf>
<PmtId>
<InstrId>InstrI d2</InstrId>
<EndToEndId>End ToEndId2</EndToEndId>
<TxId>TxId2</TxId>
</PmtId>
<PmtTpInf>
<SvcLvl>
<Cd>xxxx-some value-xxxx</Cd>
</SvcLvl>
<LclInstrm>
<Prtry>Prtry2 </Prtry>
</LclInstrm>
</PmtTpInf>
<IntrBkSttlmA mt Ccy="Ccy2">xxxx-some value-xxxx</IntrBkSttlmAmt>
<AccptncDtTm>xx xx-some value-xxxx</AccptncDtTm>
<InstdAmt Ccy="EUR">xxxx-some value-xxxx</InstdAmt>
<XchgRate>xxx x-some value-xxxx</XchgRate>
<ChrgBr>xxxx-some value-xxxx</ChrgBr>
<ChrgsInf>
<ChrgsAmt Ccy="EUR">xxxx-some value-xxxx</ChrgsAmt>
<ChrgsPty>
<FinInstnId />
</ChrgsPty>
</ChrgsInf>
<InstgAgt>
<FinInstnId />
</InstgAgt>
<UltmtDbtr>
<Nm>Nm2</Nm>
</UltmtDbtr>
<Dbtr>
<Nm>Nm2</Nm>
<PstlAdr>
<AdrLine>AdrLin e3</AdrLine>
<AdrLine>AdrLin e4</AdrLine>
<Ctry>Ctry2</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BIC>BIC2</BIC>
<IBEI>IBEI2</IBEI>
<BEI>BEI2</BEI>
<EANGLN>EANGLN2 </EANGLN>
<USCHU>USCHU2 </USCHU>
<DUNS>DUNS2</DUNS>
<BkPtyId>BkPtyI d2</BkPtyId>
<TaxIdNb>TaxIdN b2</TaxIdNb>
<PrtryId>
<Id>Id2</Id>
<Issr>Issr2</Issr>
</PrtryId>
</OrgId>
</Id>
<CtryOfRes>Ctry OfRes2</CtryOfRes>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>xxxx-some value-xxxx</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId />
</DbtrAgt>
<CdtrAgt>
<FinInstnId />
</CdtrAgt>
<Cdtr>
<Nm>Nm2</Nm>
<CtryOfRes>Ctry OfRes2</CtryOfRes>
</Cdtr>
<CdtrAcct>
<Id />
</CdtrAcct>
<UltmtCdtr>
<Nm>Nm2</Nm>
</UltmtCdtr>
<InstrForCdtrAg t>
<Cd>HOLD</Cd>
<InstrInf>Instr Inf2</InstrInf>
</InstrForCdtrAgt >
<Purp>
<Cd>Cd2</Cd>
</Purp>
<RgltryRptg>
<DbtCdtRptgInd> DEBT</DbtCdtRptgInd>
<Authrty>
<AuthrtyNm>Auth rtyNm2</AuthrtyNm>
<AuthrtyCtry>Au thrtyCtry2</AuthrtyCtry>
</Authrty>
<RgltryDtls>
<Cd>Cd2</Cd>
<Amt Ccy="EUR">xxxx-some value-xxxx</Amt>
<Inf>Inf2</Inf>
</RgltryDtls>
</RgltryRptg>
<RltdRmtInf>
<RmtId>RmtId2 </RmtId>
<RmtLctnMtd>EDI C</RmtLctnMtd>
<RmtLctnElctrnc Adr>RmtLctnElct rncAdr2</RmtLctnElctrncA dr>
<RmtLctnPstlAdr >
<Nm>Nm2</Nm>
<Adr>
<AdrTp>PBOX</AdrTp>
<AdrLine>AdrLin e6</AdrLine>
<AdrLine>AdrLin e7</AdrLine>
<AdrLine>AdrLin e8</AdrLine>
<AdrLine>AdrLin e9</AdrLine>
<AdrLine>AdrLin e10</AdrLine>
<StrtNm>StrtNm2 </StrtNm>
<BldgNb>BldgNb2 </BldgNb>
<PstCd>PstCd2 </PstCd>
<TwnNm>TwnNm2 </TwnNm>
<CtrySubDvsn>Ct rySubDvsn2</CtrySubDvsn>
<Ctry>Ctry2</Ctry>
</Adr>
</RmtLctnPstlAdr>
</RltdRmtInf>
<RmtInf>
<Ustrd>Ustrd4 </Ustrd>
<Ustrd>Ustrd5 </Ustrd>
<Ustrd>Ustrd6 </Ustrd>
</RmtInf>
</CdtTrfTxInf>
<CdtTrfTxInf>
<PmtId>
<InstrId>InstrI d3</InstrId>
<EndToEndId>End ToEndId3</EndToEndId>
<TxId>TxId3</TxId>
</PmtId>
<PmtTpInf>
<SvcLvl>
<Cd>SEPA</Cd>
</SvcLvl>
<LclInstrm>
<Prtry>Prtry3 </Prtry>
</LclInstrm>
</PmtTpInf>
<IntrBkSttlmA mt Ccy="Ccy3">xxxx-some value-xxxx</IntrBkSttlmAmt>
<AccptncDtTm>xx xx-some value-xxxx</AccptncDtTm>
<InstdAmt Ccy="EUR">xxxx-some value-xxxx</InstdAmt>
<XchgRate>xxx x-some value-xxxx</XchgRate>
<ChrgBr>xxxx-some value-xxxx</ChrgBr>
<ChrgsInf>
<ChrgsAmt Ccy="EUR">xxxx-some value-xxxx</ChrgsAmt>
<ChrgsPty>
<FinInstnId />
</ChrgsPty>
</ChrgsInf>
<InstgAgt>
<FinInstnId />
</InstgAgt>
<UltmtDbtr>
<Nm>Nm3</Nm>
</UltmtDbtr>
<Dbtr>
<Nm>Nm3</Nm>
<PstlAdr>
<AdrLine>AdrLin e5</AdrLine>
<AdrLine>AdrLin e6</AdrLine>
<Ctry>Ctry3</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BIC>BIC3</BIC>
<IBEI>IBEI3</IBEI>
<BEI>BEI3</BEI>
<EANGLN>xxxx-some value-xxxx</EANGLN>
<USCHU>xxxx-some value-xxxx</USCHU>
<DUNS>xxxx-some value-xxxx</DUNS>
<BkPtyId>BkPtyI d3</BkPtyId>
<TaxIdNb>TaxIdN b3</TaxIdNb>
<PrtryId>
<Id>Id3</Id>
<Issr>Issr3</Issr>
</PrtryId>
</OrgId>
</Id>
<CtryOfRes>Ctry OfRes3</CtryOfRes>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>IBAN3</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId />
</DbtrAgt>
<CdtrAgt>
<FinInstnId />
</CdtrAgt>
<Cdtr>
<Nm>Nm3</Nm>
<CtryOfRes>Ctry OfRes3</CtryOfRes>
</Cdtr>
<CdtrAcct>
<Id />
</CdtrAcct>
<UltmtCdtr>
<Nm>Nm3</Nm>
</UltmtCdtr>
<InstrForCdtrAg t>
<Cd>PHOB</Cd>
<InstrInf>Instr Inf3</InstrInf>
</InstrForCdtrAgt >
<Purp>
<Cd>Cd3</Cd>
</Purp>
<RgltryRptg>
<DbtCdtRptgInd> BOTH</DbtCdtRptgInd>
<Authrty>
<AuthrtyNm>Auth rtyNm3</AuthrtyNm>
<AuthrtyCtry>Au thrtyCtry3</AuthrtyCtry>
</Authrty>
<RgltryDtls>
<Cd>Cd3</Cd>
<Amt Ccy="EUR">xxxx-some value-xxxx</Amt>
<Inf>Inf3</Inf>
</RgltryDtls>
</RgltryRptg>
<RltdRmtInf>
<RmtId>RmtId3 </RmtId>
<RmtLctnMtd>URI D</RmtLctnMtd>
<RmtLctnElctrnc Adr>RmtLctnElct rncAdr3</RmtLctnElctrncA dr>
<RmtLctnPstlAdr >
<Nm>Nm3</Nm>
<Adr>
<AdrTp>HOME</AdrTp>
<AdrLine>AdrLin e11</AdrLine>
<AdrLine>AdrLin e12</AdrLine>
<AdrLine>AdrLin e13</AdrLine>
<AdrLine>AdrLin e14</AdrLine>
<AdrLine>AdrLin e15</AdrLine>
<StrtNm>StrtNm3 </StrtNm>
<BldgNb>BldgNb3 </BldgNb>
<PstCd>PstCd3 </PstCd>
<TwnNm>TwnNm3 </TwnNm>
<CtrySubDvsn>Ct rySubDvsn3</CtrySubDvsn>
<Ctry>Ctry3</Ctry>
</Adr>
</RmtLctnPstlAdr>
</RltdRmtInf>
<RmtInf>
<Ustrd>Ustrd7 </Ustrd>
<Ustrd>Ustrd8 </Ustrd>
<Ustrd>Ustrd9 </Ustrd>
</RmtInf>
</CdtTrfTxInf>
<CdtTrfTxInf>
<PmtId>
<InstrId>InstrI d4</InstrId>
<EndToEndId>End ToEndId4</EndToEndId>
<TxId>TxId4</TxId>
</PmtId>
<PmtTpInf>
<SvcLvl>
<Cd>SEPA</Cd>
</SvcLvl>
<LclInstrm>
<Prtry>Prtry4 </Prtry>
</LclInstrm>
</PmtTpInf>
<IntrBkSttlmA mt Ccy="Ccy4">xxxx-some value-xxxx</IntrBkSttlmAmt>
<AccptncDtTm>xx xx-some value-xxxx</AccptncDtTm>
<InstdAmt Ccy="EUR">xxxx-some value-xxxx</InstdAmt>
<XchgRate>xxx x-some value-xxxx</XchgRate>
<ChrgBr>xxxx-some value-xxxx</ChrgBr>
<ChrgsInf>
<ChrgsAmt Ccy="EUR">xxxx-some value-xxxx</ChrgsAmt>
<ChrgsPty>
<FinInstnId />
</ChrgsPty>
</ChrgsInf>
<InstgAgt>
<FinInstnId />
</InstgAgt>
<UltmtDbtr>
<Nm>Nm4</Nm>
</UltmtDbtr>
<Dbtr>
<Nm>Nm4</Nm>
<PstlAdr>
<AdrLine>AdrLin e7</AdrLine>
<AdrLine>AdrLin e8</AdrLine>
<Ctry>Ctry4</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BIC>BIC4</BIC>
<IBEI>IBEI4</IBEI>
<BEI>BEI4</BEI>
<EANGLN>EANGLN4 </EANGLN>
<USCHU>USCHU4 </USCHU>
<DUNS>xxxx-some value-xxxx</DUNS>
<BkPtyId>BkPtyI d4</BkPtyId>
<TaxIdNb>TaxIdN b4</TaxIdNb>
<PrtryId>
<Id>Id4</Id>
<Issr>Issr4</Issr>
</PrtryId>
</OrgId>
</Id>
<CtryOfRes>Ctry OfRes4</CtryOfRes>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>IBAN4</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId />
</DbtrAgt>
<CdtrAgt>
<FinInstnId />
</CdtrAgt>
<Cdtr>
<Nm>Nm4</Nm>
<CtryOfRes>Ctry OfRes4</CtryOfRes>
</Cdtr>
<CdtrAcct>
<Id />
</CdtrAcct>
<UltmtCdtr>
<Nm>Nm4</Nm>
</UltmtCdtr>
<InstrForCdtrAg t>
<Cd>TELB</Cd>
<InstrInf>Instr Inf4</InstrInf>
</InstrForCdtrAgt >
<Purp>
<Cd>Cd4</Cd>
</Purp>
<RgltryRptg>
<DbtCdtRptgInd> CRED</DbtCdtRptgInd>
<Authrty>
<AuthrtyNm>Auth rtyNm4</AuthrtyNm>
<AuthrtyCtry>Au thrtyCtry4</AuthrtyCtry>
</Authrty>
<RgltryDtls>
<Cd>Cd4</Cd>
<Amt Ccy="EUR">xxxx-some value-xxxx</Amt>
<Inf>Inf4</Inf>
</RgltryDtls>
</RgltryRptg>
<RltdRmtInf>
<RmtId>RmtId4 </RmtId>
<RmtLctnMtd>EMA L</RmtLctnMtd>
<RmtLctnElctrnc Adr>RmtLctnElct rncAdr4</RmtLctnElctrncA dr>
<RmtLctnPstlAdr >
<Nm>Nm4</Nm>
<Adr>
<AdrTp>BIZZ</AdrTp>
<AdrLine>AdrLin e16</AdrLine>
<AdrLine>AdrLin e17</AdrLine>
<AdrLine>AdrLin e18</AdrLine>
<AdrLine>AdrLin e19</AdrLine>
<AdrLine>AdrLin e20</AdrLine>
<StrtNm>StrtNm4 </StrtNm>
<BldgNb>BldgNb4 </BldgNb>
<PstCd>PstCd4 </PstCd>
<TwnNm>TwnNm4 </TwnNm>
<CtrySubDvsn>Ct rySubDvsn4</CtrySubDvsn>
<Ctry>Ctry4</Ctry>
</Adr>
</RmtLctnPstlAdr>
</RltdRmtInf>
<RmtInf>
<Ustrd>Ustrd1 0</Ustrd>
<Ustrd>Ustrd1 1</Ustrd>
<Ustrd>Ustrd1 2</Ustrd>
</RmtInf>
</CdtTrfTxInf>
<CdtTrfTxInf>
<PmtId>
<InstrId>InstrI d5</InstrId>
<EndToEndId>End ToEndId5</EndToEndId>
<TxId>TxId5</TxId>
</PmtId>
<PmtTpInf>
<SvcLvl>
<Cd>SEPA</Cd>
</SvcLvl>
<LclInstrm>
<Prtry>Prtry5 </Prtry>
</LclInstrm>
</PmtTpInf>
<IntrBkSttlmA mt Ccy="Ccy5">xxxx-some value-xxxx</IntrBkSttlmAmt>
<AccptncDtTm>xx xx-some value-xxxx</AccptncDtTm>
<InstdAmt Ccy="EUR">xxxx-some value-xxxx</InstdAmt>
<XchgRate>1.1 </XchgRate>
<ChrgBr>xxxx-some value-xxxx</ChrgBr>
<ChrgsInf>
<ChrgsAmt Ccy="EUR">xxxx-some value-xxxx</ChrgsAmt>
<ChrgsPty>
<FinInstnId />
</ChrgsPty>
</ChrgsInf>
<InstgAgt>
<FinInstnId />
</InstgAgt>
<UltmtDbtr>
<Nm>Nm5</Nm>
</UltmtDbtr>
<Dbtr>
<Nm>Nm5</Nm>
<PstlAdr>
<AdrLine>AdrLin e9</AdrLine>
<AdrLine>AdrLin e10</AdrLine>
<Ctry>Ctry5</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BIC>BIC5</BIC>
<IBEI>IBEI5</IBEI>
<BEI>BEI5</BEI>
<EANGLN>EANGLN5 </EANGLN>
<USCHU>USCHU5 </USCHU>
<DUNS>DUNS5</DUNS>
<BkPtyId>BkPtyI d5</BkPtyId>
<TaxIdNb>TaxIdN b5</TaxIdNb>
<PrtryId>
<Id>Id5</Id>
<Issr>Issr5</Issr>
</PrtryId>
</OrgId>
</Id>
<CtryOfRes>Ctry OfRes5</CtryOfRes>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>xxxx-some value-xxxx</IBAN>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId />
</DbtrAgt>
<CdtrAgt>
<FinInstnId />
</CdtrAgt>
<Cdtr>
<Nm>Nm5</Nm>
<CtryOfRes>Ctry OfRes5</CtryOfRes>
</Cdtr>
<CdtrAcct>
<Id />
</CdtrAcct>
<UltmtCdtr>
<Nm>Nm5</Nm>
</UltmtCdtr>
<InstrForCdtrAg t>
<Cd>CHQB</Cd>
<InstrInf>Instr Inf5</InstrInf>
</InstrForCdtrAgt >
<Purp>
<Cd>Cd5</Cd>
</Purp>
<RgltryRptg>
<DbtCdtRptgInd> DEBT</DbtCdtRptgInd>
<Authrty>
<AuthrtyNm>Auth rtyNm5</AuthrtyNm>
<AuthrtyCtry>Au thrtyCtry5</AuthrtyCtry>
</Authrty>
<RgltryDtls>
<Cd>Cd5</Cd>
<Amt Ccy="EUR">xxxx-some value-xxxx</Amt>
<Inf>Inf5</Inf>
</RgltryDtls>
</RgltryRptg>
<RltdRmtInf>
<RmtId>RmtId5 </RmtId>
<RmtLctnMtd>POS T</RmtLctnMtd>
<RmtLctnElctrnc Adr>RmtLctnElct rncAdr5</RmtLctnElctrncA dr>
<RmtLctnPstlAdr >
<Nm>Nm5</Nm>
<Adr>
<AdrTp>MLTO</AdrTp>
<AdrLine>AdrLin e21</AdrLine>
<AdrLine>AdrLin e22</AdrLine>
<AdrLine>AdrLin e23</AdrLine>
<AdrLine>AdrLin e24</AdrLine>
<AdrLine>AdrLin e25</AdrLine>
<StrtNm>StrtNm5 </StrtNm>
<BldgNb>BldgNb5 </BldgNb>
<PstCd>PstCd5 </PstCd>
<TwnNm>TwnNm5 </TwnNm>
<CtrySubDvsn>Ct rySubDvsn5</CtrySubDvsn>
<Ctry>Ctry5</Ctry>
</Adr>
</RmtLctnPstlAdr>
</RltdRmtInf>
<RmtInf>
<Ustrd>Ustrd1 3</Ustrd>
<Ustrd>Ustrd1 4</Ustrd>
<Ustrd>Ustrd1 5</Ustrd>
</RmtInf>
</CdtTrfTxInf>
</pacs.008.001.01 >
</Document>

[MohamedAliSalim]

Did you find the solution ?

Did you find the solution ? I also want to convert xml file with same your file type iso 20022 to CSV

[SioSio]

You can find it immediately by searching the internet.

https://docs.microsoft.com/en-us/dotnet/standard/linq/generate-text-files-xml

[Riya Bajpai]

To convert XML to CSV, you need to follow some steps-
1) Open the XML file and select all the text by clicking Ctrl + A then copy it by clicking Ctrl+C.
2) Open Notepad++ and paste the text from the previous step.
You will need to the delete the first two lines in the document:
"SourceOpti ons
XPath/RenderXSL"
3) From the top menu, open the Language sub-menu, then select XML.
4) After you choose the correct language, click File, then Save As. Choose where to save the file and click Save.
5) Open Excel and click on File from the ribbon bar.
6) Choose Open and Browse.
7) Locate the file you saved in the previous steps and choose Open
8) A new pop-up box is displayed. Choose As an XML table and click OK
9) Another pop-up is displayed, to alert you that this source has no schema. Ignore this error and click OK
10) You should now see the Excel sheet populated with all the correct fields

[cetpainfotech]

Converting an XML file to CSV can be a straightforward process if you have the right tools. Here are the general steps you can follow:

Parse the XML file using an XML parser library in your preferred programming language (e.g. Python's ElementTree or lxml library).
Extract the data from the XML file and reformat it into a CSV format, which typically involves creating a header row and populating subsequent rows with data values.
Write the CSV data to a file.
Here is an example Python code snippet that demonstrates the conversion of an XML file to CSV using ElementTree:

import csv
import xml.etree.Eleme ntTree as ET

# Parse the XML file
tree = ET.parse('data. xml')
root = tree.getroot()

# Extract the data and write to CSV file
with open('data.csv' , 'w', newline='') as csvfile:
writer = csv.writer(csvf ile)

# Write header row
header = [elem.tag for elem in root[0]]
writer.writerow (header)

# Write data rows
for child in root:
row = [elem.text for elem in child]
writer.writerow (row)

if you need assistance with any aspect of XML or CSV data processing, consider contacting CETPA Infotech. Our experienced instructors and flexible training options can help you master the tools and techniques needed to work with data in any format.