Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I have a XML file which contains some empty tags and some values with ''. I need to remove all empt

User_6DRK2Oct 10 2022

<Envelope xmlnsxsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:swift:xsd:envelope">

<AppHdr xmlns="urn:iso:std:iso:20022:tech:xsd:head.001.001.02">

<Fr>

<FIId>

<FinInstnId>

<BICFI>SBZAZAJJ</BICFI>

</FinInstnId>

</FIId>

</Fr>

<To>

<FIId>

<FinInstnId>

<BICFI>CABLZAJJ</BICFI>

</FinInstnId>

</FIId>

</To>

<BizMsgIdr>221010IDOBNJZLBS</BizMsgIdr>

<MsgDefIdr>pacs.009.001.08</MsgDefIdr>

<BizSvc>sarb.samos.01</BizSvc>

<MktPrctc>

<Regy>/REC/FPZAR</Regy>

<Id>FEDS,</Id>

</MktPrctc>

<CreDt>2022-10-10T14:02:22+02:00</CreDt>

</AppHdr>

<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pacs.009.001.08">

<FICdtTrf>

<GrpHdr>

<MsgId>221010IDOBNJZLBS</MsgId>

<CreDtTm>2022-10-10T14:02:22+02:00</CreDtTm>

<NbOfTxs>1</NbOfTxs>

<IntrBkSttlmDt>2022-10-12</IntrBkSttlmDt>

<SttlmInf>

<SttlmMtd>CLRG</SttlmMtd>

</SttlmInf>

</GrpHdr>

<CdtTrfTxInf>

<PmtId>

<InstrId>221010IDOBNJZLBS</InstrId>

<EndToEndId>CABLJJ7554SBZAJJ</EndToEndId>

<TxId>221010IDOBNJZLBS</TxId>

</PmtId>

<PmtTpInf>

<CtgyPurp>

<Cd>CORT</Cd>

</CtgyPurp>

</PmtTpInf>

<IntrBkSttlmAmt Ccy="ZAR">1800109.57</IntrBkSttlmAmt>

<IntrBkSttlmDt>2022-10-12</IntrBkSttlmDt>

<InstgAgt>

<FinInstnId>

<BICFI>SBZAZAJJ</BICFI>

</FinInstnId>

</InstgAgt>

<InstdAgt>

<FinInstnId>

<BICFI>CABLZAJJ</BICFI>

</FinInstnId>

</InstdAgt>

<IntrmyAgt1>

<FinInstnId/>

</IntrmyAgt1>

<Dbtr>

<FinInstnId>

<BICFI>SBZAZAJJ</BICFI>

</FinInstnId>

</Dbtr>

<DbtrAcct>

<Id>

<Othr>

<Id>7990304</Id>

</Othr>

</Id>

</DbtrAcct>

<DbtrAgt>

<FinInstnId>

<BICFI>SBZAZAJJ</BICFI>

</FinInstnId>

</DbtrAgt>

<DbtrAgtAcct>

<Id>

<Othr>

<Id>7990304</Id>

</Othr>

</Id>

</DbtrAgtAcct>

<CdtrAgt>

<FinInstnId>

<BICFI>v_bene_swiftno</BICFI>

</FinInstnId>

</CdtrAgt>

<CdtrAgtAcct>

<Id/>

<Id>

<Othr/>

</Id>

</CdtrAgtAcct>

<Cdtr>

<FinInstnId>

<BICFI>CABLZAJJ</BICFI>

<Nm>MERCANTILE BANK LTD</Nm>

<PstlAdr>

<TwnNm>MERCANTILE BANK LTD</TwnNm>

<Ctry>v_iso_country</Ctry>

</PstlAdr>

</FinInstnId>

</Cdtr>

</CdtTrfTxInf>

<SplmtryData>

<Envlp>

<ENTRY_WAREHOUSE_POSTING>

<SPINOFF_SEQ_N>1</SPINOFF_SEQ_N>

<UNIQUE_ENTRY_N>1</UNIQUE_ENTRY_N>

<STATUS_I>N</STATUS_I>

<TRANS_A>4600000</TRANS_A>

<INFOS_TRANS_N>112616</INFOS_TRANS_N>

<BUSNES_TRANS_C>IDXB</BUSNES_TRANS_C>

<SYSTEM_FLAG_I>I</SYSTEM_FLAG_I>

<BANK_C>9991121</BANK_C>

<BUY_SELL_I>B</BUY_SELL_I>

<RATE_2_R>18.1423</RATE_2_R>

<NR_SWIFT_LOCTN_C>JJ</NR_SWIFT_LOCTN_C>

<TO_BANK_ACNT_N>7990304</TO_BANK_ACNT_N>

<SWIFT_C>NFEX</SWIFT_C>

<SPOT_FORWARD_I>S</SPOT_FORWARD_I>

<DESC_1_X>221010IDOBNJZLBS</DESC_1_X>

<FROM_BANK_ACNT_N>0300568</FROM_BANK_ACNT_N>

<EQIVLNT_A>1800109.57</EQIVLNT_A>

<DEALING_BANK_ACNT_N>9991121</DEALING_BANK_ACNT_N>

<CURENCY_CONVRSN_R>2.7554</CURENCY_CONVRSN_R>

<VALUE_D>2022-10-12</VALUE_D>

<TRANS_D>2022-10-10</TRANS_D>

<SECNDRY_CURENCY_C>ZAR</SECNDRY_CURENCY_C>

<REF_N>99NJZLBS</REF_N>

<NR_SWIFT_C>CABL</NR_SWIFT_C>

<NR_SWIFT_ADRES_X>00000000000</NR_SWIFT_ADRES_X>

<NR_ITT_ADRES_X>000000000000000</NR_ITT_ADRES_X>

<RUN_D>2022-10-10</RUN_D>

<COMPANY_N>1</COMPANY_N>

<SOURCE_REF_X>221010IDOBNJZLBS</SOURCE_REF_X>

<REMITTER_REF_X>CABLJJ7554SBZAJJ</REMITTER_REF_X>

<SENDER_BANK>SBZAZAJJXX</SENDER_BANK>

<RECEIVER_BANK>SBZAZAJJXX</RECEIVER_BANK>

<ORD_CUST>T03130</ORD_CUST>

<BEN_CUST>T03130</BEN_CUST>

<CLS_IND>N</CLS_IND>

<CURENCY_C>MUR</CURENCY_C>

<SOURCE_SYSTEM_C>FEDS</SOURCE_SYSTEM_C>

<ENTERED_D>2022-10-10</ENTERED_D>

<p24_source_sid>PRISM</p24_source_sid>

</ENTRY_WAREHOUSE_POSTING>

</Envlp>

</SplmtryData>

</FICdtTrf>

</Document>

</Envelope>
Comments
Post Details
Added on Oct 10 2022
#pl-sql-xml-programming, #xml
3 comments
423 views