Command csv2xml


Name

csv2xml converts a csv file to an xml file

Synopsis

csv2xml [ serialization options ] [options] [csvfile]


Options

-root rootnameUse "rootname" as the root element name, default "root"
-row rowname use "rowname" as each row's element name, default "row"
-col colname use "colname" as each column's element name (or for attribute normal format, the attribute prefix)
-colnames names Use a sequence or , separated list of strings to specify the column names
-delim delimchar deliminate columns with delimchar, default ","
-tab Use tab char as delimitor. Synonymous for -delim <[ "&#009;" ]>
-quote quotechar quote with quote character, default "
-header read 1 row from the csv file and use as column names (element or attribute)
-attr Output in attribute normal format (each column is an attribute), default row normal format
-skip lines Skip # lines before reading header or data
-trimTrim the output by ignoring any data after the last column specified in -colnames or -header
-max #Combine the data in the last field by ignoring any more delimiters after the # of fields is specifed, or if # is <=0 then use the number of colums
csvfile Name of the csv file to convert, otherwise stdin. Default "-" (stdin)



Supports the standard [ serialization options ]

If -colnames is specified, its argument is taken to be either a sequence of strings, or a single string which is "," seperated which specifieds the column names to be used.
if -header is specified then the first row of the CSV file is read and the values used as column names.
If both -colnames and -header are specified then -colnames takes precedence but the header is still read (and ignored).

The input CSV file is read using the text encoding serialization options.


Examples


Example
echo foo,bar | csv2xml

Result
<root>
   <row>
	  <col>foo</col>
	  <col>bar</col>
   </row>
</root>

Return Value

Returns 0 if the conversion is successful

Commands
CategoryCommands

There are no comments on this page.
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki