Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get SQL Loader to skip a column in a CSV file?

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

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 03 Aug 1999 17:07:37 -0400
Message-ID: <37A75A18.34D834EC@Unforgettable.com>


Ok. Wasn't aware of that. I'm not a heavy duty Excel user. I live in the UNIX and Oracle world. My PC only exists to provide a platform to run a telnet session.

Ken

Thomas Kyte wrote:

> 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:
>
> >> >
> >> > What are these CSV files that everyone keeps
> >> mentioning?
> >> Comma seperated values. AKA Comma Delimited.
> >> 12,45,6,bill,New York
> >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 :)
>
Received on Tue Aug 03 1999 - 16:07:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US