Sponsored Content
Full Discussion: how to put those in Dbase
Top Forums Shell Programming and Scripting how to put those in Dbase Post 302234169 by dennis.jacob on Tuesday 9th of September 2008 08:47:19 AM
Old 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

help need help on wine how to put in

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

how to put a # in a file

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

Where should I put the script?

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

How to put the default value

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

how to put it in a column

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

put $,.

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 this out put ?

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

How to sort df -h out put :

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

Need to put semicolon

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

SFTP PUT

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
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)
All times are GMT -4. The time now is 01:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy