Sponsored Content
Top Forums Shell Programming and Scripting Extract XML tag value from file Post 302727463 by srattani on Tuesday 6th of November 2012 09:20:50 AM
Old 11-06-2012
Extract XML tag value from file

Hello,

Hope you are doing fine. I have an log file which looks like as follows:

Code:
Some junk text1
Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: [<?xml version="1.0" encoding="UTF-8"?><BAI2><ASOFDATE>120315</ASOFDATE><ACCOUNT><ACCOUNT_ID>123456</ACCOUNT_ID><ACCOUNT_CUR>USD</ACCOUNT_CUR></ACCOUNT></BAI2>]
Some jun text 2
Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: [<?xml version="1.0" encoding="UTF-8"?><BAI2><ASOFDATE>120315</ASOFDATE><ACCOUNT><ACCOUNT_ID>654321</ACCOUNT_ID><ACCOUNT_CUR>USD</ACCOUNT_CUR></ACCOUNT></BAI2>]
.................................................................................

I would like to create a file that would extract account number from <ACCOUNT_ID> tag. The expected output is:

123456
654321
.........

Please advise. Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unable to extract a tag from a very long XML message

Hi I have a log file which contain XML message. I want to extract the value between the tag : <businessEventId>13201330</businessEventId> i.e., 13201330. I tried the following commands but as the message is very long, unable to do it. Attached is the log file. Please provide inputs. --... (3 Replies)
Discussion started by: Sapna_Sai
3 Replies

2. Shell Programming and Scripting

how to extract the info in the tag from a xml file

Hi All, Do anyone of you have any idea how to extract each<info> tag to each different file. I have 1000 raw files, which come in every 15 mins.( I am using bash) I have tried my script as below, but it took hours to finish, which is inefficiency. perl -n -e '/^<info>/ and open FH,">file".$n++;... (2 Replies)
Discussion started by: natalie23
2 Replies

3. Shell Programming and Scripting

extract xml tag based on condition

Hi All, I have a large xml file of invoices. The file looks like below: <INVOICES> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>1234</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>2345</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME>... (9 Replies)
Discussion started by: angshuman
9 Replies

4. Shell Programming and Scripting

XML tag replacement from different XML file

We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the... (0 Replies)
Discussion started by: balrajg
0 Replies

5. Shell Programming and Scripting

Extract multiple xml tag value into CSV format

Hi All, Need your assistance on another xml tag related issue. I have a xml file as below: <INVOICES> <INVOICE> <BILL> <BILL_NO>1234</BILL_NO> <BILL_DATE>01 JAN 2011</BILL_DATE> </BILL> <NAMEINFO> <NAME>ABC</NAME> </NAMEINFO> </INVOICE> <INVOICE> <BILL> <BILL_NO>5678</BILL_NO>... (12 Replies)
Discussion started by: angshuman
12 Replies

6. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

7. Shell Programming and Scripting

Extract TAG name and XPATH from XML file via shellscript

Hi, Here is a sample xml file and expected output. I need to extract the element/tag name (not value) and xpath (sample output.txt). But the main problem is I put here one simple xml file where I can clearly see the number of elements, but in real time I have a xml file which have over 500... (18 Replies)
Discussion started by: BithunC
18 Replies

8. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>... (9 Replies)
Discussion started by: srkmish
9 Replies

9. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ... (19 Replies)
Discussion started by: pchang
19 Replies

10. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies
Mail::Field::Date(3)					User Contributed Perl Documentation				      Mail::Field::Date(3)

NAME
Mail::Field::Date - a date header field INHERITANCE
Mail::Field::Date is a Mail::Field SYNOPSIS
use HTTP::Date 'time2iso'; my $field = Mail::Field->new(Date => time2iso()); DESCRIPTION
Represents one "Date" header field. METHODS
Constructors Mail::Field::Date->combine(FIELDS) See "Constructors" in Mail::Field Mail::Field::Date->extract(TAG, HEAD [, INDEX ]) See "Constructors" in Mail::Field Mail::Field::Date->new(TAG [, STRING | OPTIONS]) See "Constructors" in Mail::Field "Fake" constructors $obj->create(OPTIONS) See ""Fake" constructors" in Mail::Field $obj->parse() See ""Fake" constructors" in Mail::Field Accessors $obj->set(OPTIONS) -Option --Default Time undef TimeStr undef Time => SECONDS TimeStr => STRING A string acceptable to Date::Parse. $obj->stringify() See "Accessors" in Mail::Field $obj->tag() Mail::Field::Date->tag() See "Accessors" in Mail::Field Smart accessors $obj->text([STRING]) See "Smart accessors" in Mail::Field $obj->time([TIME]) Query (or change) the TIME (as stored in the field) in seconds. DIAGNOSTICS
Error: Undefined subroutine <method> called Mail::Field objects use autoloading to compile new functionality. Apparently, the mehod called is not implemented for the specific class of the field object. SEE ALSO
This module is part of the MailTools distribution, http://perl.overmeer.net/mailtools/. AUTHORS
The MailTools bundle was developed by Graham Barr. Later, Mark Overmeer took over maintenance without commitment to further development. Mail::Cap by Gisle Aas <aas@oslonett.no>. Mail::Field::AddrList by Peter Orbaek <poe@cit.dk>. Mail::Mailer and Mail::Send by Tim Bunce <Tim.Bunce@ig.co.uk>. For other contributors see ChangeLog. LICENSE
Copyrights 1995-2000 Graham Barr <gbarr@pobox.com> and 2001-2007 Mark Overmeer <perl@overmeer.net>. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See http://www.perl.com/perl/misc/Artistic.html perl v5.16.3 2012-12-21 Mail::Field::Date(3)
All times are GMT -4. The time now is 08:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy