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" | ||
>> ( | >> ( |