Sql*Loader question with comma-delimited records

From: <rory_at_PROBLEM_WITH_INEWS_DOMAIN_FILE>
Date: 24 Feb 1995 05:49:17 GMT
Message-ID: <3ijs0t$7r4_at_legba.synergy.net>


	After 5 years with Oracle, I've finally been forced to write
	some Sql*Loader scripts, and I have a quick and hopefully easy
	question.  I have a comma-delimited file, and I can't get Sql*Loader
	to skip past the first few. Any ideas? I've managed to use Loader
	to load variable-length data if:
		1) I load ALL the columns (which I don't want to do)
		2) I know the offset of the first row I want (I don't
		   because it's variable length records!)

	Surely there must be some way of saying that this is a variable
	length record split by commas, and I want to load field 3 and 5?

	Now I know why I've used perl all these years to parse files and
	turn them into insert statements:-)

	Rory Reynoldson
	rory_at_inetnebr.com
Received on Fri Feb 24 1995 - 06:49:17 CET

Original text of this message