|
|
| Re: Oracle express - How to Read a CSV File [message #93081 is a reply to message #93077] |
Thu, 26 December 2002 21:03   |
Hey
Messages: 5
Registered: December 2002
|
Junior Member |
|
|
... and u thk u will get an answer uh? "desert" man!! u have entered a desert. a board that can not even answer a fundamental Q on DW like the diff between OLAP and Data Mining, u thk it will answer this..
this board is a desert. u can see mirages perpaps, but no reality
|
|
|
|
| Re: Oracle express - How to Read a CSV File [message #93107 is a reply to message #93077] |
Tue, 21 January 2003 20:04 |
Andrew Calder
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
This is directly from Express Language Help (in Express Administrator for version 6.x) - in the FILEREAD command:
CSV
Specifies that the data is in CSV (comma-separated values) format. You must use the FIELD and SPACE attributes to specify the location of the data in the record. See Table 1.
CSV files are a common output format that is generated by spreadsheet programs such as Microsoft Excel. Each line of characters in a source file is treated as a single record. Each field in the record is separated by a comma by default. You can use the DELIMITER keyword to specify some other character as field delimiter.
If a group of characters in the input record is enclosed by double quotation marks, all of the following rules apply:
n If the group includes the delimiter character, it is treated as a literal instead of as a delimiter.
n If a double quotation mark (") is included in the group of characters, then it must be followed by another double quotation mark.
n If a linefeed character (n) is included in the group of characters, then it is ignored.
n Any spaces or tabs that occur before or after the double quotation marks that enclose the group of characters will be ignored.
-----------
Does that point you in the right direction?
Andrew
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
