|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
|
|||
|
|||
|
SQL*LDR prob
I hope someone can help me with this (or point me to some documentation for it).
I'm using sql*ldr to load a flat file. The char data in the file is enclosed by quotes (") - I take care of those with the 'optionally enclosed by' syntax. Unfortunately, some of these data within the narrative fields also contain quotes. For example, a file might look like this: 0990|"column1"|"A great forum is called "DEV SHED". It really works!"|03/17/2004|....... This record would reject because of the quotes within the text. Any ideas? Thanks. Last edited by jabs : March 17th, 2004 at 03:24 PM. |
|
#2
|
|||
|
|||
|
sqlloader
Kindly use the following control file script to load the required data
Load data infile * truncate into table testraj fields terminated by "|" optionally enclosed by "'" (sno , coln1, remark "replace(:remark,'\"','')") BEGINDATA 0990|"column1"|"A great forum is called "DEV SHED". It really works!" It is assumed that the data is separated by '|' symbol. again this script will remove the " symbol within data for example "DEV SHED" will be as DEV SHED. so if " symbol has to be retained you can write a separate script (function) and use in place of replace. hope this will be helpful to you. regards raj |
|
#3
|
|||
|
|||
|
Thanks Raj
I thought I already wrote to say thanks - but I guess not. So....Thanks!
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > SQL*LDR prob |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|