Home » Developer & Programmer » Data Integration » Oracle express - How to Read a CSV File
Oracle express - How to Read a CSV File [message #93077] Fri, 20 December 2002 00:14 Go to next message
vishwakumar
Messages: 2
Registered: December 2002
Junior Member
Hi
I have a rerquirement ro read a cv file and load the data into my Express objects.Is there any sample or example for the same ????
Re: Oracle express - How to Read a CSV File [message #93081 is a reply to message #93077] Thu, 26 December 2002 21:03 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Problems with Oracle Express OLAP Client on WindowsXP
Next Topic: Re: Data Warehouse Jobs - Richmond, VA
Goto Forum:
  


Current Time: Fri Mar 29 10:36:35 CDT 2024