07-17-2017
Quote:
Originally Posted by
archana25
i have a unix script which generates the csv file. the data in csv file is dynamic. how can i convert/move the data from csv file to xml. please suggest
What do you mean by dynamic? Do you men that the data in the file changes every time the script is run? Do you mean that the columns keep changing position for some reason?
Can you show examples of the data in both the CSV format you get and the XML format you wish to obtain?
Andrew
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello,
How can I take a file in XML format and convert it to a comma separated format? Is there any scripts or programs that can
do this for Unix? I tried surfing the net for such an application, but everything seems to be for Windows OS. Any help or suggestions are greatly appreciated.
... (2 Replies)
Discussion started by: oscarr
2 Replies
2. Shell Programming and Scripting
Hi All,
My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
Discussion started by: Anil.Wmg
10 Replies
3. Programming
Before i start doing something, I wanted to know whether the approach to compare XML file with UNIX file system structure. I have a pre-configured file(contains a list of paths to executables) and i need to check against the UNIX directory structure. what are the various approches should i use ? I... (6 Replies)
Discussion started by: shafi2all
6 Replies
4. UNIX for Advanced & Expert Users
Hi all,
Am looking for a way to generate XML based on XSDs so that the final XML need not be validated against the XSDs again.
Here is the part of the XSD
<xsd:element name="first_element">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="val"/>
</xsd:sequence>
... (0 Replies)
Discussion started by: matrixmadhan
0 Replies
5. Shell Programming and Scripting
Hi,
I have a .xml file in unix. We are passing this file through a xml parser.
But we are getting some control characters from input file and XML parser is failing for the control character in file.Now I am getting following error,
Error at byte 243206625 of file filename_$.xml:
Error... (1 Reply)
Discussion started by: fantushmayu
1 Replies
6. Shell Programming and Scripting
Hello Gurus,
We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this .
Problem Definition:
/Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below... (19 Replies)
Discussion started by: KRAMA
19 Replies
7. Shell Programming and Scripting
Hi all,
Have to generate an xml having information related to files in the directory
Suppose i have file
file1.xml (datafile)
file2.xml (datafile)
file3.xml (metafile)
Now i need to generate an xml in the format >>
<?xml version="1.0" encoding="UTF-8"?>
<AuditFile Version="2.0">... (8 Replies)
Discussion started by: abhinav192
8 Replies
8. Shell Programming and Scripting
Hi all,
I am trying to generate an XML file from a flatfile in ksh/bash (could also use perl at a pinch, but out of my depth there!).
I have found several good solutions on this very forum for cases where the header line in the file forms the XML tags, however my flatfile is as follows:... (5 Replies)
Discussion started by: ianmrid
5 Replies
9. Shell Programming and Scripting
Hi,
I have a xml file and a xsd file(xml schema file). Here using unix script i wanted to validate the xml file by referring to xsd file. The validation is in terms of Datatype,Field length and null values. If the data present in the xml file is not matching in terms of datatype,field length... (3 Replies)
Discussion started by: shree11
3 Replies
10. UNIX for Advanced & Expert Users
we have a CSV which i need to convert to XML using Perl or Unix shell scripting.
I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies
XML2(1) General Commands Manual XML2(1)
NAME
xml2 - convert xml documents in a flat format
2xml - convert flat format into xml
html2 - convert html documents in a flat format
2html - convert flat format into html
csv2 - convert csv files in a flat format
2csv - convert flat format into csv
SYNOPSIS
<xml2|2xml|html2|2html|csv2|2csv> > outfile < infile
DESCRIPTION
There are six tools. Except csv2 and and 2csv they don't take any command-line arguments. They are all simple filters which can be used to
read files from standard input in one format and output it to standard output in another format.
The flat format used by the tools is specific to these tools. It is a syntax for representing structured markup in a way that makes it
easy to process with line-oriented tools. The same format is used for HTML and XML; in fact, you can think of html2 as converting HTML to
XHTML and running xml2 on the result; likewise 2html and 2xml. (Of course, this isn't how the implementation works.)
SEE ALSO
This program does normally not include any documentation in form of manpages. However it has a real excellent documentation online with a
lot of example. In fact this manpage was based on this documentation.
Please find it on:
http://dan.egnor.name/xml2/ref
Examples can be found here:
http://dan.egnor.name/xml2/examples
AUTHOR
xml2 was written by Dan Egnor.
This manpage was written by Patrick Schoenfeld <schoenfeld@in-medias-res.com> for the Debian project, but may be used by others under the
same terms as xml2 is distributed.
BUGS
Bugs can be reported through the Debian Bug tracking system.
7h february 2008 XML2(1)