Re: SQL Loader Control file

Originally posted by starigopula

> Hi,

>

> Is there a way we can specify multiple delimiter in the FIELDS
> TERMINATED BY Clause?

>

> Here is a sample control file..... The data to load may be delimieted
> either with a | or , or ?

>

> Thanks in advance.........

>

> CTL File

> -----------

>

> LOAD DATA

> INFILE 'datafile.dat'

> INTO TABLE test_table_name

> APPEND

> FIELDS TERMINATED BY ','

> (

> COL1 INTEGER EXTERNAL,

> COL2 INTEGER EXTERNAL,

> COL3 ...
No. More importantly, what would be the purpose of specifying multiple kinds of delimiters in a delimited file?

Keep it simple... just use "Edit - Replace" in your notepad and replace all delimiters to one kind.

Regards

/Rauf

--
Posted via http://dbforums.com