Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extract a value from an xml file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract a value from an xml file
# 15  
Old 01-26-2017
Quote:
Originally Posted by Aia
Please, try the following:

Code:
perl -nle '/<PORTED_NUM>([\d-]*)</ and print $1' mrn6430.xml

How can I use this same perl command but o display alpha values? for ex if I want:

display the value of MSGCODE in this xml:

Code:
Thu Jan 26 13:44:21 2017 Logged Message:473|<?xml version="1.0" encoding="UTF-8"?><GENERIC_NOTIFICATION><HEADER><ORIGINATOR>SMG</ORIGINATOR><DESTINATION>ENSEMBLE</DESTINATION><MESSAGE_ID>NXT106361086</MESSAGE_ID><MSGTYPE>NOT</MSGTYPE><TIMESTAMP>01262017184421</TIMESTAMP></HEADER><REQ_NO>7778017026777200</REQ_NO><VER_ID_REQ>00</VER_ID_REQ><MSGDATA><PORTED_NUM>512-202-1767</PORTED_NUM><MSGCODE>SOA1012I</MSGCODE><MSGTEXT>Port Request Authorized by Old Service Provider 6646</MSGTEXT></MSGDATA></GENERIC_NOTIFICATION>

# 16  
Old 01-26-2017
Quote:
Originally Posted by mrn6430
How can I use this same perl command but o display alpha values? for ex if I want:

display the value of MSGCODE in this xml:

Code:
Thu Jan 26 13:44:21 2017 Logged Message:473|<?xml version="1.0" encoding="UTF-8"?><GENERIC_NOTIFICATION><HEADER><ORIGINATOR>SMG</ORIGINATOR><DESTINATION>ENSEMBLE</DESTINATION><MESSAGE_ID>NXT106361086</MESSAGE_ID><MSGTYPE>NOT</MSGTYPE><TIMESTAMP>01262017184421</TIMESTAMP></HEADER><REQ_NO>7778017026777200</REQ_NO><VER_ID_REQ>00</VER_ID_REQ><MSGDATA><PORTED_NUM>512-202-1767</PORTED_NUM><MSGCODE>SOA1012I</MSGCODE><MSGTEXT>Port Request Authorized by Old Service Provider 6646</MSGTEXT></MSGDATA></GENERIC_NOTIFICATION>

I am certainly not a perl expert, but from what I know about REs, the following should do what you want:
Code:
perl -nle '/<MSGCODE>([^<]*)</ and print $1' file

which, if file contains the data above, produces the output:
Code:
SOA1012I

Is that what you're trying to do?
This User Gave Thanks to Don Cragun For This Post:
mrn6430
# 17  
Old 02-07-2017
Perfect. Thank you so much
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract Element from XML file

<?xml version = '1.0' encoding =... (8 Replies)
Discussion started by: Siva SQL
8 Replies

2. Shell Programming and Scripting

Extract a particular xml only from an xml jar file

Hi..need help on how to extract a particular xml file only from an xml jar file... thanks! (2 Replies)
Discussion started by: qwerty000
2 Replies

3. Shell Programming and Scripting

Extract data from XML file

Hi , I have input file as XML. following are input data #complex.xml <?xml version="1.0" encoding="UTF-8"?> <TEST_doc xmlns="http://www.w3.org/2001/XMLSchema-instance"> <ENTRY uid="123456"> <protein> <name>PROT001</name> <organism>Human</organism> ... (1 Reply)
Discussion started by: mohan sharma
1 Replies

4. Shell Programming and Scripting

Extract XML tag value from file

Hello, Hope you are doing fine. I have an log file which looks like as follows: Some junk text1 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: Some jun text 2 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: ... (3 Replies)
Discussion started by: srattani
3 Replies

5. Shell Programming and Scripting

Extract values from an XML File

Hi, I need to capture all the attributes with delete next to it. The source XML file is attached. The output should contain something like this below: Attributes = legacyExchangeDN Action = Delete Username = Hero Joker Loginid = joker09 OU =... (4 Replies)
Discussion started by: prvnrk
4 Replies

6. Shell Programming and Scripting

extract a pattern from a xml file

Hello All, I want to write a shell script for extracting a content from a xml file the xml file looks like this: <Variable name="moreAxleInfo"> <type> <Table> <type> <NamedType> <type> <TypeRef... (11 Replies)
Discussion started by: suvendu4urs
11 Replies

7. Shell Programming and Scripting

Extract XML content from a file

310439 2012-01-11 03:44:42,291 INFO PutServlet:? - Content of the Message is:="1.0" encoding="UTF-8"?><ESP_SSIA_ACC_FEED> 310440 <BATCH_ID>12345678519</BATCH_ID> 310441 <UID>3498748823</UID> 310442 <FEED_TYPE>FULL</FEED_TYPE> 310443 <MART_NAME>SSIA_DM_TRANSACTIONS</MART_NAME> 310444... (11 Replies)
Discussion started by: arukuku
11 Replies

8. Shell Programming and Scripting

Extract details from XML file

Hi , I have one xml file contains more than 60 lines. I need to extract some details from the file and store it in new file.Not the whole file Please find the xml file below: <?xml version="1.0" encoding="UTF-8"?> <DeploymentDescriptors xmlns="http://www.tibco.com/xmlns/dd"> ... (6 Replies)
Discussion started by: ckchelladurai
6 Replies

9. UNIX for Dummies Questions & Answers

Extract Field Value from XML file

Hi, Within a UNIX shell script I need to extract a value from an XML field. The field will contain different values but will always be 6 digits in length. E.g.: <provider-id>999999</provider-id> I've tried various ways but no luck. Any ideas how I might get the provider id (in this case... (2 Replies)
Discussion started by: pnclayt11
2 Replies

10. Shell Programming and Scripting

How to extract text from xml file

I have some xml files that got created by exporting a website from RedDot. I would like to extract the cost, course number, description, and meeting information. <?xml version="1.0" encoding="UTF-16" standalone="yes" ?> - <PAG PAG0="3AE6FCFD86D34896A82FCA3B7B76FF90" PAG3="525312"... (3 Replies)
Discussion started by: chrisf
3 Replies
Login or Register to Ask a Question