Re: How to get SQL Loader to skip a column in a CSV file?

A copy of this was sent to Kenneth C Stahl <BluesSax_at_Unforgettable.com> (if that email address didn't require changing) On Tue, 03 Aug 1999 15:35:16 -0400, you wrote:

>teybrady_at_my-deja.com wrote:
>
>> >
>> > What are these CSV files that everyone keeps
>> mentioning?
>> >
>> >
>> Comma seperated values. AKA Comma Delimited.
>>
>> 12,45,6,bill,New York
>>
>> Sent via Deja.com http://www.deja.com/
>> Share what you know. Learn what you don't.
>
>Hmm. I would think that there might be some value in using terminology
>that is universally accepted. To say that a file is "comma delimited" is
>understood quite widely, the abbreviation "CSV" isn't something that
>appears in any of the Oracle literature I've ever read and I've never
>seen it elsewhere.
>

this one is universally accepted by spreadsheet users. Its not an Oracle term but it is a pretty popular one -- dates way back for pc users.

Its a universal import/export format for them. The file extension is .csv. If you "file save as" in excel, you'll find the file type "(comma delimited) .csv" is one of the formats. one of the easiest ways to get data from a web browser into excel is to return a .csv file..

I guess its as universal as YMMV, ROTFL, IMO, IMHO, OTOH (now lets see how many emails I get asking what those mean :)

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 03 1999 - 15:21:58 CDT