09-09-2008
Not a fair idea...the best one is to use the XML Parser module in perl....I have givena try like this :
Quote:
sed -e 's/<\(.*\)>\(.*\)<\(.*\)/\1=\2/' -e 's/<//g' -e 's/>//g' < filename | sed -e '/^[\?/]/d' -e '/^$/d' -e '/^Log/d' -e 's/"//g' -e 's/\(.*\)=\(.*\)/\2/' | xargs -n8 | awk -v q="'" '{ print "insert into table table_name values("q$1q","q$2q","q$3q","q$4q","q$5q","q$6q","q$7q");" }'
Output:
Quote:
insert into table table_name values('83efeae5190809080000080410','Upstream.TEL','MAKE','mms','purple','20080908000008.985701','20 080908000009.293774');
insert into table table_name values('83efeae5190809080001290411','Upstream.TEL','DEL','MMS','20080908000129.697712','200809080001 30.135911','NOK');
Last edited by dennis.jacob; 09-09-2008 at 09:54 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how the hell do you put wine in because i don't know i have mandrake please tell how to put in (1 Reply)
Discussion started by: amicrawler
1 Replies
2. Shell Programming and Scripting
Hello,
Sir's,
I would like to ask for help. This is my problem, i am working for a mbs for aix,hp-ux and solaris. And i am making a script that will automatically implement the said mbs.
For example it will automatically change the permmisions of /usr/bin, /etc/passwd and so on. . . .... (7 Replies)
Discussion started by: invinzin21
7 Replies
3. UNIX for Dummies Questions & Answers
Hi Guys,
I'm a new to the UNIX. Let say I have a 1 simple script to stop and start vnc service. I want to use that script for support because my network connection to my client side is not stable and every time I have to use a long command to restart vnc.
Where should I put that script?... (3 Replies)
Discussion started by: akuslive
3 Replies
4. Shell Programming and Scripting
Hi guys
Iam looking for a small help.I wrote a script. in that iam trying to take the default value ,when we press enter.this part iam struggling can somebody help please
Example:
do u need this server:
For this one if we press enter it has to take server name as... (4 Replies)
Discussion started by: coolkid
4 Replies
5. Shell Programming and Scripting
Simple question ..What is the easiest way to list my output in a column
like so
dddd dddd dddd dddd
output
dddd
dddd
dddd
dddd
Thanks (3 Replies)
Discussion started by: bombcan
3 Replies
6. UNIX for Dummies Questions & Answers
original content:
0000000000 TIAA-CREF
0000000000 CAREMARK
all said and done, i'd like to look like this:
$00,000,000.00 TIAA-CREF
$00,000,000.00 CAREMARK (2 Replies)
Discussion started by: tjmannonline
2 Replies
7. UNIX for Advanced & Expert Users
How to get to know, where are the current logs been updated in the system
or most recently updated logs in the system.
consider /usr/abc/def
and inside the def folder , i have many subfolders
The command out put ,need to give me the log files and there location , which are... (7 Replies)
Discussion started by: sidharthmellam
7 Replies
8. Solaris
Hello every one ,
I am just trying to sort df -h out in a particular order to differentiate SAN disks and local disks .. does any body have any script or any useful command ??
thanks in advance .. (8 Replies)
Discussion started by: new2uniks
8 Replies
9. Shell Programming and Scripting
Hi guys,
I want to write script so that i can put semicolon after every numeric
e.g
input would be like that
50060E80058F49A4
Output should be
50:06:0E:80:05:8F:49:A4
Please help
Thanks & Regards
Nirjhar (11 Replies)
Discussion started by: nirjhar17
11 Replies
10. Shell Programming and Scripting
Hi,
ServerA (SFTP server)
ServerB (SFTP client)
ServerB:> sftp user@ServerA
ServerB:> put sample.txt
ServerB:> get sample2.txt
My question is that which machine will encrypt the sample.txt and sample2.txt files.
Thanks (8 Replies)
Discussion started by: Arpit Narula
8 Replies
LEARN ABOUT DEBIAN
xml::parser::lite::tree
XML::Parser::Lite::Tree(3pm) User Contributed Perl Documentation XML::Parser::Lite::Tree(3pm)
NAME
XML::Parser::Lite::Tree - Lightweight XML tree builder
SYNOPSIS
use XML::Parser::Lite::Tree;
my $tree_parser = XML::Parser::Lite::Tree::instance();
my $tree = $tree_parser->parse($xml_data);
OR
my $tree = XML::Parser::Lite::Tree::instance()->parse($xml_data);
DESCRIPTION
This is a singleton class for parsing XML into a tree structure. How does this differ from other XML tree generators? By using
XML::Parser::Lite, which is a pure perl XML parser. Using this module you can tree-ify simple XML without having to compile any C.
For example, the following XML:
<foo woo="yay"><bar a="b" c="d" />hoopla</foo>
Parses into the following tree:
'children' => [
{
'children' => [
{
'children' => [],
'attributes' => {
'a' => 'b',
'c' => 'd'
},
'type' => 'element',
'name' => 'bar'
},
{
'content' => 'hoopla',
'type' => 'text'
}
],
'attributes' => {
'woo' => 'yay'
},
'type' => 'element',
'name' => 'foo'
}
],
'type' => 'root'
};
Each node contains a "type" key, one of "root", "element" and "text". "root" is the document root, and only contains an array ref
"children". "element" represents a normal tag, and contains an array ref "children", a hash ref "attributes" and a string "name". "text"
nodes contain only a "content" string.
METHODS
"instance()"
Returns an instance of the tree parser.
"new( options... )"
Creates a new parser. Valid options include "process_ns" to process namespaces.
"parse($xml)"
Parses the xml in $xml and returns the tree as a hash ref.
AUTHOR
Copyright (C) 2004-2008, Cal Henderson, <cal@iamcal.com>
SEE ALSO
XML::Parser::Lite.
perl v5.12.3 2011-06-04 XML::Parser::Lite::Tree(3pm)