User Tools

Site Tools


platform:format

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
platform:format [2014/02/17 04:02]
asok
platform:format [2014/02/17 04:31] (current)
asok [Supported Data Formats]
Line 71: Line 71:
 str mytable="​cacus"​ str mytable="​cacus"​
 int records_to_skip=5 int records_to_skip=5
 +str mycolumns="​xcus,​xorg,​xshort"​
  
 format "​catest",​ "​load"​ format "​catest",​ "​load"​
Line 85: Line 86:
  
 ====Supported Data Formats==== ====Supported Data Formats====
-Currently supported data formats are: //fixed////text////csv////xls// and //xlsx//+Currently supported data formats are: **fixed****text****csv****xls** and **xlsx**. When the format is not specified, the system will assume a format based on the file extension
  
-For text format, you also need to specify fdelimiter (field delimiter) and rdelimiter (record delimiter) properties.+For text format, you also need to specify ​**fdelimiter** (field delimiter) and **rdelimiter** (record delimiter) properties.
  
 <​code>​ <​code>​
   fdelimiter ","​   fdelimiter ","​
   rdelimiter "​\r\n"​   rdelimiter "​\r\n"​
-  ​skip 0+  ​
  
 </​code>​ </​code>​
  
-For fixed format, you need to specify column name, start and size together with the rdelimiter (record delimiter) property.+For fixed format, you need to specify column ​**name****start** and **size**, together with the **rdelimiter** (record delimiter) property.
  
 <​code>​ <​code>​
   dataformat FIXED   dataformat FIXED
   rdelimiter \r\n   rdelimiter \r\n
-  ​skip 0+  ​
   columns   columns
     xcus      1   20     xcus      1   20
/srv/www/htdocs/wiki/data/attic/platform/format.1392609746.txt.gz · Last modified: 2014/02/17 04:02 by asok