Revision [869]

This is an old revision of CommandCsv2xml made by DavidLee on 2009-11-22 09:28:49.

 

Command csv2xml


Name

csv2xml converts a csv file to an xml file

Synopsis

csv2xml [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 <[ "&#009;" ]>
-quote quotechar quote with quote character, default "
-encoding encoding read csv file in encoding (default "cp1252")
-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
csvfile Name of the csv file to convert, otherwise stdin. Default "-" (stdin)


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.



Example

$ echo foo,bar | csv2xml
<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