This shows you the differences between two versions of the page.
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 |