Extracting specific fields from an XML file

Top Forums UNIX for Beginners Questions & Answers Extracting specific fields from an XML file

03-27-2018

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Yes. Remove the "," in the print statements or set OFS="".

Last edited by RudiC; 03-28-2018 at 02:57 AM..

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need Help in extracting data from XML File

Hi All My input file is an XML and it has some tags and data rows at end. Starting of data rows is <rs:data> and ending of data rows is </rs:data>. Within sample data rows (2 rows) shown below, I want to extract data value after equal to sign (until space or "/" sign). So if XML data...

2. Shell Programming and Scripting

Extracting the tag name from an xml file

Hi, My requirement is something like this, I have a xml file that contains some tags and nested tags, <n:tag_name1> <n:sub_tag1>val1</n:sub_tag1> <n:sub_tag2>val2</n:sub_tag2> </n:tag_name1> <n:tag_name2> <n:sub_tag1>value</n:sub_tag1> ...

3. Shell Programming and Scripting

Reading XML file and extracting value

Dear All, I am reading one XML file to extract value from the particular tag:- Sample xml is below:- <KeyValuePairs> <Key>TestString</Key> <Value>Test12_Pollings</Value> </KeyValuePairs> I want to read the value for the KEY tag and there will be multiple key tags :- awk...

4. Shell Programming and Scripting

Help in extracting fields from a file

I have an input file with contents like: 203969 OrdAcctCycChg USAGE_DAEMON1 203970 OrdAcctCycChg USAGE_DAEMON2 203971 OrdAcctCycChg USAGE_DAEMON3 203972 OrdAcctCycChg USAGE_DAEMON4 I need to extract variables in first column...

5. Shell Programming and Scripting

Need help in extracting data from xml file

Hello, This is my first post in here, so excuse me if I sound too noob here! I need to extract the path "/apps/mp/installedApps/V61/HRO/hrms_01698_A_qa.ear" from the below xml extract. The path will always appear with the key "binariesURL" <deployedObject...

6. UNIX for Dummies Questions & Answers

Extracting data from an xml file

Hello, Please can someone assist. I have the following xml file: <?xml version="1.0" encoding="utf-8" ?> - <PUTTRIGGER xmlns:xsd="http://www.test.org/2001/XMLSchema" xmlns:xsi="http://www.test.org/2001/XMLSchema-instance" APPLICATIONNUMBER="0501160" ACCOUNTNAME="Mrs S Test"...

7. UNIX for Dummies Questions & Answers

Extracting values from an XML file

Hello People, I have an xml file from which I need to extract the values of the parameters using UNIX shell commands. Ex : Input is like : <Name>Roger</Name> or <Address>MI</Address> I need the output as just : Roger or MI with the tags removed. Please help.

8. Shell Programming and Scripting

Extracting fields from file

I am need to extract a number of values from a file, put have now clue how to do this. The file looks like this: # My file Dest=87;CompatibleSystemSoftwareVersion=2.5300-; Dest=87;ImageVersion=000061f3;SystemSoftwareVersion=2.5300;CDN=http://my.backup.com/download.txt;CDN_Timeout=30; I...

9. Shell Programming and Scripting

Extracting a part of XML File

Hi Guys, I have a very large XML feed (2.7 MB) which crashes the server at the time of parsing. Now to reduce the load on the server I have a cron job running every 5 min.'s. This job will get the file from the feed host and keep it in the local machine. This does not solve the problem as...

10. Shell Programming and Scripting

extracting XML file using sed

Hello folks I want to extract data between certain tag in XML file using 'sed' <xml> ......... .......... <one>XXXXXXXXXXXXXXXXXXXX</one> ...... Anyone ?Thank you

LEARN ABOUT DEBIAN

hwloc-assembler

HWLOC-ASSEMBLER(1)						       hwloc							HWLOC-ASSEMBLER(1)

NAME

       hwloc-assembler - Assemble multiple XML topologies

SYNOPSIS

       hwloc-assembler [options] output.xml [--name <name1>] input1.xml [--name <name2>] input2.xml ...

OPTIONS

       -n --name <name>
	      Set <name> in the AssemblerName info attribute of the next input topology root to ease identification within the final global topol-
	      ogy.

       -f --force
	      Ignore errors while reading input files.

       -v --verbose
	      Verbose messages.

DESCRIPTION

       hwloc-assembler combines the input XML topologies and exports the resulting global topologies to a new XML file.  All inputs are  inserting
       as children of the global root object.  Each input topology root is annotated with info attributes before insertion.  AssemblerIndex is set
       to the index within the list of inputs.	AssemblerName is set to the name given with --name if any.  hwloc-assembler-remote offers a  fron-
       tend for assembling remote nodes topologies without having to manually gather and transfer each of them.

EXAMPLES

       To assemble two nodes topologies:

	   $ hwloc-assembler output.xml --name host1 host1.xml --name host2 host2.xml

RETURN VALUE

       Upon successful execution, hwloc-assembler returns 0.

       hwloc-assembler will return nonzero if any kind of error occurs, such as (but not limited to) failure to parse the command line.

SEE ALSO

       hwloc(7), lstopo(1), hwloc-assembler-remote(1)

1.4.1								   Feb 27, 2012 						HWLOC-ASSEMBLER(1)

UNIX for Beginners Questions & Answers