This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
integration:rawdata:delimited:example [2012/10/26 15:34] 127.0.0.1 external edit |
integration:rawdata:delimited:example [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| -> ; | -> ; | ||
| -> create table "COUNTRIES" | -> create table "COUNTRIES" | ||
| - | >> options "DELMITED COLUMN=',' RECORD='\r\n' QUOTES" | + | >> options "DELIMITED COLUMN=',' RECORD='\r\n' QUOTES" |
| >> physical "dat/countries.csv" | >> physical "dat/countries.csv" | ||
| >> ( | >> ( | ||
| Line 57: | Line 57: | ||
| -> ; | -> ; | ||
| -> create table "STATES" | -> create table "STATES" | ||
| - | >> options "DELMITED COLUMN='\t' RECORD='\r\n' QUOTES" | + | >> options "DELIMITED COLUMN='\t' RECORD='\r\n' QUOTES" |
| >> physical "dat/states.txt" | >> physical "dat/states.txt" | ||
| >> ( | >> ( | ||
| Line 74: | Line 74: | ||
| -> ; | -> ; | ||
| -> create table "GENDERS" | -> create table "GENDERS" | ||
| - | >> options "DELMITED COLUMN='|' RECORD='\r\n' QUOTES" | + | >> options "DELIMITED COLUMN='|' RECORD='\r\n' QUOTES" |
| >> physical "dat/genders.txt" | >> physical "dat/genders.txt" | ||
| >> ( | >> ( | ||