Home » RDBMS Server » Server Utilities » Re: Variable extraction in a comma delimited file
Re: Variable extraction in a comma delimited file [message #368081] Fri, 10 March 2000 11:29 Go to next message
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 Go to previous message
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
Previous Topic: Re: Problem with importing Views
Next Topic: Re: Executing Mutliple CTL files from sqlloader
Goto Forum:
  


Current Time: Mon May 23 21:27:11 CDT 2022