|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Convert XML to CSV using awk or shell script
Post 302931294 by sea on Monday 12th of January 2015 11:49:01 AM
01-12-2015
"This wont work!", was my first thought.
A technicaly halftruth/incorecctness, but helpfull to create a better image, saying would be:
XML is like a Database, whereas CSV/TXT is a Tablesheet at best.
It is NO problem to make all data from a table into a database,but moving a database into a table, even when there are only 5 entries, is already rather complex. (unless the DB was used as a simple table
)
You need to decide which values/cathegories you want to drop in favor of more important data, OR which values you want to store in another file - if you want to preserve ALL data.
hth
A technicaly halftruth/incorecctness, but helpfull to create a better image, saying would be:
XML is like a Database, whereas CSV/TXT is a Tablesheet at best.
It is NO problem to make all data from a table into a database,but moving a database into a table, even when there are only 5 entries, is already rather complex. (unless the DB was used as a simple table
)You need to decide which values/cathegories you want to drop in favor of more important data, OR which values you want to store in another file - if you want to preserve ALL data.
hth
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all,
Can you send me a script file the changes .xml to .csv file.
Thanks,
Srinivasa (4 Replies)
Discussion started by: srinivasaphani
4 Replies
2. Shell Programming and Scripting
Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,... (2 Replies)
Discussion started by: rossingi_33
2 Replies
3. Shell Programming and Scripting
Hi Scripting gurus,
I need to convert following text snippet into csv. please help
Input
heading1 = data1
heading2 = data2
..
..
heading n = data n
heading 1 = data1
..
..
Output
data1,data2,....,data n (3 Replies)
Discussion started by: azs0309
3 Replies
4. Shell Programming and Scripting
Can any one give the idea on this, please.
I have the following XML file and wants to convert into CSV(comma separated value) format.
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Waveset PUBLIC 'waveset.dtd' 'waveset.dtd'>
<Waveset>
<Object name='ra8736'>
<Attribute name='ADDRESS'... (2 Replies)
Discussion started by: kumar04
2 Replies
5. Shell Programming and Scripting
Hi
Written some script to convert csv to html but could not add table headers.Below are the errors iam getting
./csv2html | more
+ awk -v border=1 -v width=10 -v bgcolor=black -v fgcolor=white
BEGIN { printf("<table border=\"%d\" bordercolor=\"%s\" width=\"%d\"... (2 Replies)
Discussion started by: zeebala1981
2 Replies
6. Shell Programming and Scripting
Hi All,
I will be getting a huge XML file with a lot of records in it. I need to convert it into multiple data files.
SAMPLE XML FILE
<ABSProductCatalog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ProductSalesHierachy>
- <Portfolios>
- <Portfolio productCode="P1">
... (8 Replies)
Discussion started by: ragha81
8 Replies
7. Shell Programming and Scripting
Hi,
I have an xml file and I want to convert it with awk in to a csv file
Test.xml
<Worksheet ss:Name="Map1">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60">
<Row>
<Cell><Data... (6 Replies)
Discussion started by: research3
6 Replies
8. Shell Programming and Scripting
I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with... (7 Replies)
Discussion started by: dineshydv
7 Replies
9. Shell Programming and Scripting
I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly.
CODE:
#!/usr/bin/perl
# Script to illustrate how to parse a simple XML file
# and pick out all the values for a specific element, in... (1 Reply)
Discussion started by: rspwilliam
1 Replies
10. Shell Programming and Scripting
Hi,
I am not familiar with shell scripting. Please help to convert xml files to csv files using xsltproc command in bash script. Find the xml sample
<?xml version="1.0"?>
-<Source xmlns="link">
<CompanyCd>DSP</CompanyCd>
<SrcSysCd>DSPS</SrcSysCd>
<CountryCd>45</CountryCd>
... (2 Replies)
Discussion started by: mathina
2 Replies
LEARN ABOUT SUNOS
mlib_imagelookup_inp
mlib_ImageLookUp_Inp(3MLIB) mediaLib Library Functions mlib_ImageLookUp_Inp(3MLIB) NAME
mlib_ImageLookUp_Inp - table lookup, in place SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ] #include <mlib.h> mlib_status mlib_ImageLookUp_Inp(mlib_image *srcdst, const void **table); DESCRIPTION
The mlib_ImageLookUp_Inp() function maps the source image to the destination image, in place, by using the user-specified lookup table. The following equation is used: srcdst[x][y][i] = table[i][srcdst[x][y][i]] PARAMETERS
The function takes the following arguments: srcdst Pointer to first source and destination image. table Pointer to lookup table. The data type of the lookup table is the same as the destination image. The number of entries in the lookup table is determined by the type of the input image. The format of the lookup table is: table[channel][index] The MLIB_BYTE type entries are indexed from 0 to 255. The MLIB_SHORT type entries are indexed from -32768 to -1, then from 0 to 32767. The MLIB_USHORT type entries are indexed from 0 to 65535. The MLIB_INT type entries are indexed from -2147483648 to -1, and then from 0 to 2147483647. RETURN VALUES
The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Evolving | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
mlib_ImageLookUp(3MLIB), mlib_ImageLookUp2(3MLIB), mlib_ImageLookUpMask(3MLIB), attributes(5) SunOS 5.10 10 Nov 2004 mlib_ImageLookUp_Inp(3MLIB)