parsing comma separated value files (CSVs)

From: Reg <RegBurgess_at_Lucent.com>
Date: Wed, 05 Jan 2000 15:07:30 -0800
Message-ID: <3873CEB2.7CC70D87_at_Lucent.com>

[Quoted] I have a number of these "comma separated value files" that I want/need to load into a database.
My main questions are;

1. Is this a fairly "standard" format ? {and/or is it likely to have been exported from another database product ?}
2. Is there a utility to either load them directly or convert them to SQL*Loader format ?

They have this general form;

Table,table_name
Fields,field_name_1, field_name_2
,value_1,value_2
,value_1_2,value_2_2

where "Table" and "Fields" are keywords, table_name is the name of an existing table in the current schema, the list of fields is terminated by the end-of-line, each line of values starts with a comma, there appears to be no special end-of-file, just no more lines of values

any help would be greatly appreciated, etc.

\R Received on Thu Jan 06 2000 - 00:07:30 CET