Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extract value for string

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract value for string
# 1  
Old 09-05-2015
Extract value for string
Hi all,

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

Code:
<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 ::


Code:
<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  
Old 09-05-2015
Would something like this work?
Code:
sed -n 's/^.*\(<ns4:zipCode>[0-9]\{5\}<\/ns4:zipCode>\).*$/\1/p' Junaid_Subhani.file

also grep might work here
Code:
grep -o '<ns4:zipCode>[0-9]\{5\}<\/ns4:zipCode>' Junaid_Subhani.file

Last edited by Aia; 09-05-2015 at 09:31 PM..
# 3  
Old 09-05-2015
Hello Junaid Subhani,

Following may help you too in same.
Code:
awk '{match($0,/<ns4:zipCode>.*<\/ns4:zipCode>/);print substr($0,RSTART,RLENGTH)}'  Input_file

Output will be as follows.
Code:
<ns4:zipCode>40744</ns4:zipCode>

Hope this helps.

Thanks,
R. Singh
# 4  
Old 09-06-2015
Do you really need the tags? Or just the number? Try:
Code:
sed 's/^.*<ns4:zipCode>\|<\/ns4:zipCode>.*$//g' file
40744

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract every repeated string between two specific string?

Hello guys, I have problem with hpux shell script. I have one big text file that contains like SOH bla bla bla bla bla bla ETX SOH bla bla bla ETX SOH bla bla bla ETX What I need to do is save first SOH*BLA into file1.txt, save second SOH*BLA into file2.txt and so on.... (17 Replies)
Discussion started by: sembii
17 Replies

2. Shell Programming and Scripting

To Search for a string and to extract the string from the text

Hi Team I have an huge xml where i need to search for a ceratin numbers. For example 2014-05-06 15:15:41,498 INFO WebContainer : 10 CommonServicesLogs - CleansingTriggerService.invokeCleansingService Entered PUBSUB NOTIFY MESSAGE () - <?xml version="1.0" encoding="UTF-8"... (5 Replies)
Discussion started by: Kannannair
5 Replies

3. Shell Programming and Scripting

Search String and extract few lines under the searched string

Need Assistance in shell programming... I have a huge file which has multiple stations and i wanted to search particular station and extract few lines from it and the rest is not needed Bold letters are the stations . The whole file has multiple stations . Below example i wanted to search... (4 Replies)
Discussion started by: ajayram_arya
4 Replies

4. Shell Programming and Scripting

Extract a string from another string in UNIX

I have a string string="Please have a nice day and sleep well Replace_12123_31233_32134_12342 Good day" How do i replace "Replace_12123_31233_32134_1234" in the above string.?? Please help. Regards, Qwerty (3 Replies)
Discussion started by: qwertyu
3 Replies

5. Shell Programming and Scripting

Extract a string between 2 ref string from a file

Hi, May i ask if someone share some command for extracting a string between 2 ref string in a txt file My objective: i had a file with multiple lines and wants only to extract the string "watch?v=IbkAXOmEHpY" or "watch?v=<11 random character>", when i used "grep 'watch?=*' i got a results per... (4 Replies)
Discussion started by: jao_madn
4 Replies

6. Shell Programming and Scripting

to extract string from main string and string comparison

continuing from my previous post, whose link is given below as a reference https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569 consider there is create table commands in a file for eg: CREATE TABLE `Blahblahblah` ( `id` int(11) NOT NULL... (2 Replies)
Discussion started by: vivek d r
2 Replies

7. Shell Programming and Scripting

extract a string within a string using a pattern

hi all, i have a file name using the following pattern: PREFIX: AR SOURCE: LEGACY DATETIME: YYYYMMDD_HH24MISS SUFFIX: .txt sample filename: AR_LEGACY_20101104_105500.txt i want to extract the source which is LEGACY in this case. how do i do this using shell? thanks. (4 Replies)
Discussion started by: adshocker
4 Replies

8. Shell Programming and Scripting

Search for string in a file and extract another string to a variable

Hi, guys. I have one question: I need to search for a string in a file, and then extract another string from the file and assign it to a variable. For example: the contents of the file (group) is below: ... ftp:x:23: mail:x:34 ... testing:x:2001 sales:x:2002 development:x:2003 ...... (6 Replies)
Discussion started by: daikeyang
6 Replies

9. Shell Programming and Scripting

extract a sub string from a main string

i need a shell program to extract a substring from a main string.. for eg:- main string is madhu.. sub string is mad o/p:- be mad. try to solve this one (5 Replies)
Discussion started by: madhu.it
5 Replies

10. UNIX for Dummies Questions & Answers

How to extract a portion of a string from the whole string

How to extract a portion of a string from a full string using unix. For example: Say source string is = "req92374923.log" I want only the numeric portion of the string say "92374923" how to do that in Unix. (2 Replies)
Discussion started by: ds_sastry
2 Replies
Login or Register to Ask a Question