Revision [1713]

Last edited on 2011-05-16 12:33:08 by DavidLee
Additions:
||-skip lines||Skip "lines" of lines before reading header or row data||


Revision [1050]

Edited on 2009-11-25 18:16:35 by DavidLee
Additions:
%%(xml)


Revision [986]

Edited on 2009-11-25 09:50:31 by DavidLee
Additions:
====Examples====
[[Commands]]
Deletions:
====Example====


Revision [912]

Edited on 2009-11-24 17:35:48 by DavidLee
Additions:
||-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)||
||-colspecs specs||sequence or , delimited list of column specs||
||-colnames names||Use a sequence or "," delimited list of strings to specify the column names||
||-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||
||-nonorm||"No Normalize" ... Do NOT trim leading and trailing blanks from fields (defaults to normalize)||
||fixedfile||Name of the fixed file to convert, otherwise stdin. Default "-" (stdin)||
Deletions:
-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)
-colspecs specs sequence or , delimited list of column specs
-colnames names Use a sequence or "," delimited list of strings to specify the column names
-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
-nonorm "No Normalize" ... Do NOT trim leading and trailing blanks from fields (defaults to normalize)
fixedfile Name of the fixed file to convert, otherwise stdin. Default "-" (stdin)


Revision [911]

Edited on 2009-11-24 17:34:46 by DavidLee
Additions:
csv2xml [ [[SerializationOptions serialization options]] ] [options] [fixedfile]
Supports the standard [ [[SerializationOptions serialization options]] ]
Result
Deletions:
csv2xml [options] [fixedfile]
Output


Revision [868]

Edited on 2009-11-22 08:02:36 by DavidLee
Additions:
-colspecs specs sequence or , delimited list of column specs
-colnames names Use a sequence or "," delimited list of strings to specify the column names
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 fixed file is read and the values used as column names.
-colspecs is required. Its argument is a sequence or "," deliminted string of column specs. A column spec is either "start-end" or "start", where start and end are integer column positions starting at one. For example "1-3,5-6,7-9" or <[ "1-3" , "5-6" , "7-9" ]>
If the "-end" is omitted then the remainder of the line is used.
Column specs may overlap (e.g "1-10,5-12" )
fixed2xml -row item -root items -colspecs 1-5,7-9,11-15 -colnames First,Second,Third <<EOF
Deletions:
-cols colseq Use a sequence of strings to specify the column names
-widths widthseq Use the specified sequence of widths to define the fields
fixed2xml -row item -root items -widths <[ 6,4,4 ]> -cols <["First","Second","Third"]> <<EOF


Revision [865]

Edited on 2009-11-22 07:20:04 by DavidLee
Additions:
-nonorm "No Normalize" ... Do NOT trim leading and trailing blanks from fields (defaults to normalize)


Revision [864]

The oldest known version of this page was created on 2009-11-22 07:19:23 by DavidLee
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki