 |
|
|
|
 |
|
 |
||
 |
||||||||
 |
|
|||||||
|
|
 |
 |
 |
 |
|
 |
|
|
 |
|
|
 |
||||||
 |
|
||||||||
 |
 |
|
||
|
|
csvcnv.exe file.csv outfile.ext [OPTIONS] csvcnv.exe *.csv destdir /TOEXT [OPTIONS] where ext - (.dbf, .txt, .htm, .prg, .xml, .xls, .csv, .sql, .rtf) Common options
/SRCHDR - header in the first line. /SRCSEPx - where x delimiter. /SRCSEPTAB for TAB delimiter /SRCSEPSPACE for space delimiter /SRCSEPPIPE use '|' as delimiter /REVERSE - export in reverse order /ANALYZE - allows detect optimal file structure for export to DBF. /ASXML - export to Excel(xls) as xml based example: csvcnv.exe file.csv outfile.xls /ASXML /TYPES:field1:type[size],field2:type[size] allows you set types for columns (N - numeric, C - character, D- date) example1: csvcnv in.csv out.xls /TYPES:Field5:N example2: csvcnv in.csv out.xls /TYPES:Field5:N20 /FILTER:filterfile filter file format: Field name:Value|Expression Examples: single file conversion: csvcnv.exe mybase.csv out.xls /SEP; multiple file conversion: csvcnv.exe c:\base\*.csv c:\exports\ /TOSQL /SINGLEQUOTA - single quotas /DOUBLEQUOTA - double quotas /SEPx - where x delimiter SEPTAB for TAB delimiter /SEPSPACE for space delimiter /SEPPIPE use '|' as delimiter /HDR - for put the fields names in first line. /DBASE3 - DBASE III format /DBASE4 - DBASE IV format /VFP - Visual Foxpro format example: csvcnv.exe c:\base\myfile.dbf out.dbf /DBASE4 /ASFORM - one record on the one page /NUMBER - record number as first column /MAXPERPAGE - maximum records on the one page example: /MAXPERPAGE=100 /TITLE - page title example: /TITLE=Customers /COLOR - Text color example: /COLOR=#0000ff /BACKGROUND - Background color /BACKGROUND=#c0c0c0 |
||
 Copyright © HiBase Group, 2002-2008 |
||||