Sponsored Content
Top Forums Shell Programming and Scripting Extract a value from an xml file Post 302988316 by mrn6430 on Friday 23rd of December 2016 12:02:57 PM
Old 12-23-2016
Extract a value from an xml file

I have this XML file format and all in one line:

Code:
Fri Dec 23 00:14:52 2016 Logged Message:689|<?xml version="1.0" encoding="UTF-8"?><PORT_RESPONSE><HEADER><ORIGINATOR>XMG</ORIGINATOR><DESTINAT
ION>ENSEMBLE</DESTINATION><MESSAGE_ID>NXT107349698</MESSAGE_ID><MSGTYPE>PRI</MSGTYPE><TIMESTAMP>12232016061452</TIMESTAMP></HEADER><ADMIN><WIC
IS_REL_NO>5.0.0</WICIS_REL_NO><NNSP>9664</NNSP><OLSP>6529</OLSP><ONSP>6529</ONSP><REQ_NO>6664016358514349</REQ_NO><VER_ID_REQ>00</VER_ID_REQ><
VER_ID_RESP>00</VER_ID_RESP><RT>C</RT><RESP_NO>652901635838480144</RESP_NO><CD_TSENT>122220160614</CD_TSENT><REP>Port Center</REP><TEL_NO_REP>
000-207-8009</TEL_NO_REP><CHC></CHC><DD_T>122320160909</DD_T><NPQTY>00001</NPQTY></ADMIN><LINE_DATA><PORTED_NUM>990-799-1234</PORTED_NUM></LIN
E_DATA></PORT_RESPONSE>

How can I write a script to extract only the value 990-799-1234 which is the value for PORTED_NUM and store in a field.

I am using solaris 10 Unix box.



Moderator's Comments:
Mod Comment Please use correct CODE tags as required by forum rules!

Last edited by RudiC; 12-23-2016 at 01:17 PM.. Reason: Changed ICODE to CODE tags.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. UNIX for Dummies Questions & Answers

Extract Element from XML file

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

NAME
Pacemaker - Part of the Pacemaker cluster resource manager SYNOPSIS
cibadmin command [options] [data] DESCRIPTION
cibadmin - Provides direct access to the cluster configuration. Allows the configuration, or sections of it, to be queried, modified, replaced and deleted. Where necessary, XML data will be obtained using the -X, -x, or -p options OPTIONS
-?, --help This text -$, --version Version information -V, --verbose Increase debug output Commands: -u, --upgrade Upgrade the configuration to the latest syntax -Q, --query Query the contents of the CIB -E, --erase Erase the contents of the whole CIB -B, --bump Increase the CIB's epoch value by 1 -C, --create Create an object in the CIB. Will fail if the object already exists. -M, --modify Find the object somewhere in the CIB's XML tree and update it. Fails if the object does not exist unless -c is specified -P, --patch Supply an update in the form of an xml diff (See also: crm_diff) -R, --replace Recursivly replace an object in the CIB -D, --delete Delete the first object matching the supplied criteria, Eg. <op id="rsc1_op1" name="monitor"/> The tagname and all attributes must match in order for the element to be deleted -d, --delete-all When used with --xpath, remove all matching objects in the configuration instead of just the first one -5, --md5-sum Calculate the on-disk CIB digest -6, --md5-sum-versioned Calculate an on-the-wire versioned CIB digest -S, --sync (Advanced) Force a refresh of the CIB to all nodes -a, --empty Output an empty CIB Additional options: -f, --force -t, --timeout=value Time (in seconds) to wait before declaring the operation failed -s, --sync-call Wait for call to complete before returning -l, --local Command takes effect locally. Should only be used for queries -c, --allow-create (Advanced) Allow the target of a -M operation to be created if they do not exist -n, --no-children (Advanced) When querying an object, do not return include its children in the result Data: -X, --xml-text=value Retrieve XML from the supplied string -x, --xml-file=value Retrieve XML from the named file -p, --xml-pipe Retrieve XML from stdin -A, --xpath=value A valid XPath to use instead of -o -o, --scope=value Limit the scope of the operation to a specific section of the CIB. Valid values are: nodes, resources, constraints, crm_config, rsc_defaults, op_defaults, status -N, --node=value (Advanced) Send command to the specified host EXAMPLES
Query the configuration from the local node: # cibadmin --query --local Query the just the cluster options configuration: # cibadmin --query --scope crm_config Query all 'target-role' settings: # cibadmin --query --xpath "//nvpair[@name='target-role']" Remove all 'is-managed' settings: # cibadmin --delete-all --xpath "//nvpair[@name='is-managed']" Remove the resource named 'old': # cibadmin --delete --xml-text '<primitive id="old"/>' Remove all resources from the configuration: # cibadmin --replace --scope resources --xml-text '<resources/>' Replace the complete configuration with the contents of $HOME/pacemaker.xml: # cibadmin --replace --xml-file $HOME/pacemaker.xml Replace the constraints section of the configuration with the contents of $HOME/constraints.xml: # cibadmin --replace --scope constraints --xml-file $HOME/constraints.xml Increase the configuration version to prevent old configurations from being loaded accidentally: # cibadmin --modify --xml-text '<cib admin_epoch="admin_epoch++"/>' Edit the configuration with your favorite $EDITOR: # cibadmin --query > $HOME/local.xml # $EDITOR $HOME/local.xml # cibadmin --replace --xml-file $HOME/local.xml SEE ALSO: CRM shell, crm(8), crm_shadow(8) AUTHOR
Written by Andrew Beekhof REPORTING BUGS
Report bugs to pacemaker@oss.clusterlabs.org Pacemaker 1.1.7 April 2012 PACEMAKER(8)
All times are GMT -4. The time now is 04:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy