Handling arbitrary XML isn't trivial. Hopefully this should be flexible and mold itself to your input data, since it discovers columns as it goes and tries to preserve order. It decides where a 'row' is by looking for two close-tags in a row.
If it doesn't work, try nawk. If it still doesn't work, post some of your actual, unmodified input data.
ORS="\r\n" should make it more easily importable into excel or what have you.
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Hi,
I was trying some split command to pull out values like "uid=abc,ou=INTERNAL,ou=PEOPLE" into a csv file. However because of erratic nature of occurrance of rows made me stopped. Could someone help me in this? and if someone has a one liner for this?
The text file contain pattern like this... (14 Replies)
HI All,
I have a text file memory.txt which has following values.
Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600
i want to convert this file in csv format and i am using following command to do it.
sed s/_/\./g <... (3 Replies)
Hi,
I need to parse text, xml files to get the statistic numbers and prepare summary csv file.
What is the best way to parse these file and prepare csv file.
Any idea you have , please?
Regards, (2 Replies)
Hi - I am looking to convert the following text to csv. The columns may not always have data in them and they may have varying spaces but I still need to have a comma there anyway:
Sample Data:
~~~~~~~
Name Email Location Phone
Tom... (4 Replies)
Hi!
I need to realize this task.
In folder i have such files:
name1.txt
name1.pdf
name2.txt
name2.pdf
etc...
I want to scan this folder, match files with same name (name1.txt with name1.pdf, name2.txt with name2.pdf) and create files name1.xml and name2.xml, based on it. i.e:
i want... (13 Replies)
hi..
I have a text file which looks likes this
2258
4569
1239
258
473
i need to convert it into comma seperated format
eg:2258,4569,1239,258,437
pls help (8 Replies)
Hi people. I've finally converted to linux, and I'm starting to explore the amazing capabilities of the terminal. At the moment in trying to learn how to extract text using the "grep" and "sed" command. I decided to learn by trying to figure out how to solve a practical problem. I have a schedule... (4 Replies)
I have a table as following
Archive id Line Author Time Text
1fjj34 3 75jk5l 03:20 this is an evidence regarding ...
1fjj34 4 gjhhtrd 03:21 we have seen those documents before
1fjj34 10 645jmdvvb 04:00 Will you consider such an offer?... (0 Replies)
Hi,
I have a xml script, I converted it to .txt with values comma seperated using awk function. But I want the output values should be inside double quotes
My xml script (Workorders.xml) is shown like below:
<?xml version="1.0" encoding="utf-8" ?>
<scbm-extract version="3.3">... (8 Replies)
Discussion started by: Viswanatheee55
8 Replies
LEARN ABOUT DEBIAN
cgi::xml
XML(3pm) User Contributed Perl Documentation XML(3pm)NAME
CGI::XML - Perl extension for converting CGI.pm variables to/from XML
SYNOPSIS
use CGI::XML;
$q = new CGI::XML;
# convert CGI.pm variables to XML
$xml = $q->toXML;
$xml = $q->toXML($root);
# convert XML to CGI.pm variables
$q->toCGI($xml);
DESCRIPTION
The CGI::XML module converts CGI.pm variables to XML and vice versa.
CGI::XML is a subclass of CGI.pm, so it reads the CGI variables just as CGI.pm would.
METHODS
$q = new CGI::XML
creates a new instance of CGI::XML. You also have access to all of the methods in CGI.pm.
$q->toXML([$root])
where $root is an optional parameter that specifies the root element. By default, toXML will not return a root element.
$q->toCGI($xml)
where $xml is the XML you would like to convert to CGI.pm parameters. Values in the XML will overwrite any existing values if they
exist.
NOTE
CGI::XML does not currently handle multiple selections passed from HTML forms. This will be added in a future release.
AUTHOR
Jonathan Eisenzopf <eisen@pobox.com>
CONTRIBUTORS
David Black <dblack@candle.superlink.net>
SEE ALSO perl(1), XML::Parser(3).
perl v5.8.8 2004-12-05 XML(3pm)