Command csv2xml

Name

csv2xml converts a csv file to an xml file

Synopsis

csv2xml [ serialization options ] [options] [csvfile]

Options

-root rootname	Use "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 <[ " " ]>
-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
-trim	Trim 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

xmlsh - XML Shell : CommandCsv2xml