JAVA Regex with XML

Question

i have this String and i need to get the attribut Ccy to TtlIntrBkSttlmAmt with a regex.

Can you help me to have the best pattern ?

<?xml version = "1.0" encoding = "UTF-8"?>
<Document xmlns = "urn:iso:std:iso:20022:tech:xsd:pacs.008.001.02" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance">
    <FIToFICstmrCdtTrf>
        <GrpHdr>
            <MsgId>XXXXXXXXXXX</MsgId>
            <CreDtTm>2013-07-23T16:30:14</CreDtTm>
            <NbOfTxs>0</NbOfTxs>
            <TtlIntrBkSttlmAmt Ccy = "EUR">0000.00</TtlIntrBkSttlmAmt>
            <IntrBkSttlmDt>2013-07-24</IntrBkSttlmDt>
            <SttlmInf>
                <SttlmMtd>CLRG</SttlmMtd>
                <SttlmAcct>
                    <Id>
                        <IBAN>XXXXXXXXXXXXXXXX</IBAN>
                    </Id>
                </SttlmAcct>
                <ClrSys>
                    <Prtry>XXXXX</Prtry>
                </ClrSys>
            </SttlmInf>
        </GrpHdr>

Thank you.

Define ETL and tell us exactly why it prevents you from using an XML parser. I have a hard time understanding why those are incompatible. — fge
– fge, Commented Jul 24, 2013 at 8:43

user1334319 · Accepted Answer · 2013-07-24 08:43:38Z

1

I wouldn't use a Regex, use an XML parser instead. Anyway...

(?!= <TtlIntrBkSttlmAmt)Ccy = "[A-Z]+"

Should do the trick. Edit the [A-Z] group to meet your specific needs.

answered Jul 24, 2013 at 8:43

user1334319

Sign up to request clarification or add additional context in comments.

1 Comment

L. Quastana Over a year ago

Thank you for your solution but finally i have create a static fonction which convert my String to Document XML and get my attribut

L. Quastana · Accepted Answer · 2013-07-24 09:27:52Z

1

?? = DocumentBuilderFactory.newInstance().newDocumentBuilder()
         .parse( new InputSource( new StringReader( XMLLine ) ) )
         .getElementsByTagName("TtlIntrBkSttlmAmt")
         .item(0).getAttributes().getNamedItem("Ccy").getNodeValue();

answered Jul 24, 2013 at 9:27

L. Quastana

1,3461 gold badge13 silver badges35 bronze badges

Collectives™ on Stack Overflow

JAVA Regex with XML

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related