| Re: Variable extraction in a comma delimited file [message #368081] |
Fri, 10 March 2000 11:29  |
Roshan
Messages: 10
Registered: March 2000
|
Junior Member |
|
|
89898,2322232-1212323,'Good Record'
82388,2123122-1231212,'Another Good Record'
taking the above data into consideration if you wanna load it into 4 fields
you can do as below in the control file of your sqlloader
load
append
into table table_name
fields terminated by ","
(
field1,
field2 terminated by "-",
field3,
field4
)
|
|
|
|
| Re: Variable extraction in a comma delimited file [message #368083 is a reply to message #368081] |
Fri, 10 March 2000 13:11  |
Roshan D'Souza
Messages: 8
Registered: March 2000
|
Junior Member |
|
|
sorry a small mistake I did in my last reply....instead of field2 replace it by name field3 , also change the substr parameters in the 8th line.....
code re-written refer below
load
append
into table table_name
fields terminated by ","
(
field1,
field2 terminated by "-" "substr(:field2,1,7)",
field3 "substr(:field3,1,7)",
field4
)
of any use do let me know
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
