Need help in extracting data from xml file Post: 302539244

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Need help in extracting data from xml file Post 302539244 by fpmurphy on Friday 15th of July 2011 09:48:19 PM

Old

07-15-2011

Registered User

Quote:

Originally Posted by abhishek2386

I also tried this just now and working:

Code:

cat file.xml | awk '{ print$6 }' | awk -F"\"" '{ print$2}'

No need to cat the file. That is a UUOC! The following eliminates the UUOC.

Code:

awk '{ print$6 }' file.xml | awk -F"\"" '{ print$2}

You can also simply this to:

Code:

$ awk -F'[ "]' '{ print $15 }' file.xml
/apps/mp/installedApps/V61/HRO/hrms_01698_A_qa.ear

fpmurphy

View Public Profile for fpmurphy

Find all posts by fpmurphy

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Extracting Data from xml file

Hi ppl out there... Can anyone help me with the shell script to extract data from an xml file. My xml file looks like : - <servlet> <servlet-name>FrontServlet</servlet-name> <display-name>FrontServlet</display-name> ...

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

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

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

6. Shell Programming and Scripting

Extracting content from xml file

Hello All, Hope you are doing well!!!!! I have a small code in the below format in xml file: <UML:ModelElement.taggedValue> <UML:TaggedValue tag="documentation" value="This sequence

HLD_EA_0001X
HLD_DOORS_002X"/> <UML:TaggedValue tag="documentation" value="This...

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

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

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

10. UNIX for Dummies Questions & Answers

Extracting data between continuous non empty xml tags

Hi, I need help in extracting only the phone numbers between the continuous non empty xml tags in unix. I searched through a lot of forum but i did not get exact result for my query. Please help Given below is the sample pipe delimited file. I have a lot of tags before and after...

LEARN ABOUT SUNOS

intltool-extract

intltool-extract(1)						   User Commands					       intltool-extract(1)

NAME

       intltool-extract - generate header file from XML source file

SYNOPSIS

       intltool-extract [--ini-style] [--help] [--verbose] [--version] [--xml-style] [--scheme-style] source-file

DESCRIPTION

       intltool-extract  generates header files from the strings in the specified input files which gettext can use to merge strings into the .pot
       file.

OPTIONS

       The following options are supported:

       --help	       Show usage and basic help information. You can also use -H to specify this option.

       --ini-style     Specifies that the source file is of type gettext/ini.

       --scheme-style  Specifies that the source file is of type gettext/scheme.  You can also use -O to specify this option.

       --verbose       Provide additional feedback. You can also use -X to specify this option.

       --version       Show version information. You can also use -V to specify this option.

       --xml-style     Specifies that the source file is of type gettext/xml. You can also use -O to specify this option.

OPERANDS

       The following operands are supported:

       source-file     Specifies the pathname of the XML file from which to extract translatable content.

EXAMPLES

       Example 1: Generating a Header File for a Schemas File, With Verbose Output

       example% intltool-extract -O --scheme-style foo.schemas.in

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       >0	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/intltool-extracThe command-line executable for the application.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-common-devel	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |External			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       intltool-merge(1), intltool-prepare(1), intltool-unicodify(1), intltool-update(1), intltoolize(1)

NOTES

       For more information, see the I18N-HOWTO file, which is provided with the intltool source code.

       Updated by Damien Donlon, Sun Microsystems  Inc., 2003. Written by Darin Adler, Kenneth Christiansen, Maciej Stachowiak.

SunOS 5.10							    3 Apr 2003						       intltool-extract(1)