Extract value for string

Shell Programming and Scripting
1

Hi all,

I have a very long string with is basically a SOAP request message.

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><ns2:wsMessageHeader xmlns:ns2="http://integration.com/common/header/WSMessageHeader/v2" xmlns="http://integration.com/interfaces/managePrepaidInvoiceTax/v1/InvoiceTax.xsd" xmlns:ns3="http://integration.com/common/ErrorDetailsV2.xsd" xmlns:ns4="http://integration.com/interfaces/InvoiceTax/v1/InvoiceTax.xsd"><ns2:trackingMessageHeader><ns2:applicationId>AID</ns2:applicationId><ns2:applicationUserId>AID</ns2:applicationUserId><ns2:consumerId>AID</ns2:consumerId><ns2:messageId>AID-MSGID-02dd</ns2:messageId><ns2:conversationId>AID-CONVID</ns2:conversationId><ns2:timeToLive>30</ns2:timeToLive><ns2:messageDateTimeStamp>2015-09-03T23:53:11.492-05:00</ns2:messageDateTimeStamp></ns2:trackingMessageHeader></ns2:wsMessageHeader></soap:Header><soap:Body><ns4:calculatePrepaidInvoiceTax xmlns:ns4="http://integration.com/interfaces/InvoiceTax/v1/calculatePrepaidInvoiceTax.xsd" xmlns="http://integration.com/interfaces/InvoiceTax/v1/InvoiceTax.xsd" xmlns:ns2="http://integration.com/common/header/WSMessageHeader/v2" xmlns:ns3="http://integration.com/common/ErrorDetailsV2.xsd"><ns4:invoiceLineInfo><ns4:invoiceDate>2015-09-03</ns4:invoiceDate><ns4:productCategory>Service</ns4:productCategory><ns4:productText>SPP260LTE</ns4:productText><ns4:taxableAmount>35.0</ns4:taxableAmount></ns4:invoiceLineInfo><ns4:addressInfo><ns4:acceptanceLocationInfo><ns4:zipCode>40744</ns4:zipCode></ns4:acceptanceLocationInfo></ns4:addressInfo></ns4:calculatePrepaidInvoiceTax></soap:Body></soap:Envelope>

I am trying to extract this particular value ::

<ns4:zipCode>40744</ns4:zipCode>

How can I do it? I am trying the cut command but it seems to be just removing everything after <ns4:zipCode>40744</ns4:zipCode> and keeping everything before it.

I would prefer using bash commands like cut or sed.

2

Would something like this work?

sed -n 's/^.*\(<ns4:zipCode>[0-9]\{5\}<\/ns4:zipCode>\).*$/\1/p' Junaid_Subhani.file

also grep might work here

grep -o '<ns4:zipCode>[0-9]\{5\}<\/ns4:zipCode>' Junaid_Subhani.file
3

Hello Junaid Subhani,

Following may help you too in same.

awk '{match($0,/<ns4:zipCode>.*<\/ns4:zipCode>/);print substr($0,RSTART,RLENGTH)}'  Input_file

Output will be as follows.

<ns4:zipCode>40744</ns4:zipCode>

Hope this helps.

Thanks,
R. Singh

4

Do you really need the tags? Or just the number? Try:

sed 's/^.*<ns4:zipCode>\|<\/ns4:zipCode>.*$//g' file
40744