sql loader [message #592840] |
Mon, 12 August 2013 12:09 |
|
DIPRINKS
Messages: 57 Registered: July 2013 Location: Michigan
|
Member |
|
|
I have a scenario where the data file has values separated by ^.While loading this data into the table using sql loader I want to convert it into multiple lines.eg:
data file:
1|1013 park ridge~12345~irving|
2|2013 park ridge~12345~irving|
3|1013 park ridge|
while loading it into table i want the data like
ID ADDRESS
1 "1013 park ridge
12345
irving"
2 "2013 park ridge
12345
irving"
.....
My control file says:
load data
infile "/usr2/home2/adistest/h91ftp/temp/owb_test/owb_test1.csv"
preserve blanks INTO TABLE owbrep.owb_test1
TRUNCATE
fields terminated by '|' TRAILING NULLCOLS
(
id,
address
)
Please suggest what should I do?
[Updated on: Mon, 12 August 2013 12:10] Report message to a moderator
|
|
|