Categories
- All Categories
- 102 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to show XSD data in readable format in BIP xlsx output?

I am getting xml tag value of a column in XSD format in BIP xlsx report output and there is requirement to show this column data in more readable format and not in XSD format. Kindly looking for your input on the same. Note - I am using RTF template to design this report.
Below is the sample column value in XSD format:
<?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="urn:swift:xsd:envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><AppHdr xmlns="urn:iso:std:iso:20022:tech:xsd:head.001.001.02"><Fr><FIId><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></FIId></Fr><To><FIId><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></FIId></To><BizMsgIdr>2409501721009000</BizMsgIdr><MsgDefIdr>pacs.009.001.08</MsgDefIdr><BizSvc>swift.cbprplus.02</BizSvc><CreDt>2022-03-24T01:51:31.053-04:00</CreDt></AppHdr><Document xmlns="urn:iso:std:iso:20022:tech:xsd:pacs.009.001.08"><FICdtTrf><GrpHdr><MsgId>2409501921091000</MsgId><CreDtTm>2022-03-24T01:51:31.053-04:00</CreDtTm><NbOfTxs>1</NbOfTxs><SttlmInf><SttlmMtd>INDA</SttlmMtd><SttlmAcct><Id><Othr><Id>021082324</Id></Othr></Id><Ccy>USD</Ccy></SttlmAcct></SttlmInf></GrpHdr><CdtTrfTxInf><PmtId><InstrId>2409501320780000</InstrId><EndToEndId>THIS IS A COPY</EndToEndId><UETR>dd4184a1-c49a-47ac-b752-aff34e0b0b04</UETR></PmtId><PmtTpInf><InstrPrty>HIGH</InstrPrty><CtgyPurp><Cd>OTHR</Cd></CtgyPurp></PmtTpInf><IntrBkSttlmAmt Ccy="USD">1000000</IntrBkSttlmAmt><IntrBkSttlmDt>2023-05-10</IntrBkSttlmDt><InstgAgt><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></InstgAgt><InstdAgt><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></InstdAgt><Dbtr><FinInstnId><BICFI>IMFDUS3WXXX</BICFI><Nm>ACDESC_USA-CURNO1-USD-A</Nm><PstlAdr><AdrLine>ADD1</AdrLine></PstlAdr></FinInstnId></Dbtr><DbtrAgt><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></DbtrAgt><Cdtr><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></Cdtr><Purp><Cd>ADMG</Cd></Purp><RmtInf><Ustrd>/BNF/DEBIT IMF NO.1 ACCOUNT OF INDIA, XDR EQUIVALENT XXXXX, EXCHANGE RATE: ONE INR EQUALS XDR</Ustrd></RmtInf></CdtTrfTxInf></FICdtTrf></Document></Envelope>