Use a perl script (with a regular expression) to strip out the extra
quotation marks.
-----Original Message-----
From: ashok
[mailto:oracledba-ezmlmshield-x90244966.[Email address protected]
Sent: 08 August 2007 15:56
To: LazyDBA Discussion
Subject: RE: SQL Loader
This wont work because all my data is not like this.
Eg Name =""ashok""
country ="INDIA"
Address = "2,Ashok Nagar"
State = "Tamil" Nadu"
Here I will be having a problem in the columns of Name,Address,State
My actual data is Name ="ashok"
Country = INDIA
Address = 2,Ashok Nagar
State = Tamil" Nadu
If I am going to give optionally enclosed by '""' the data would become
like ashok but by data is "ashok"
Please give some solution where I can solve this issue
With Thanks and Regards,
Ashok
9840884644
-----Original Message-----
From: Norm Milan
[mailto:oracledba-ezmlmshield-x22108536.[Email address protected]
Sent: Wednesday, August 08, 2007 8:15 PM
To: LazyDBA Discussion
Subject: RE: SQL Loader
If you do not need to include the double quote in your data, you could
try:
Optionally enclosed by '""' but I have never seen this before so have no
clue as to whether it will actually work. I suspect that you may only be
allowed 1 character between apostophes.
-----Original Message-----
From: ashok
[mailto:oracledba-ezmlmshield-x32851323.[Email address protected]
Sent: Wednesday, August 08, 2007 8:26 AM
To: LazyDBA Discussion
Subject: SQL Loader
Hi,
I am using the SQL Loader to load the data to a table which I am getting
as a feed.
I have used the given the terminator as Field terminated by ','
optionally enclosed by '"'
Wherein i am getting a data for a column ex: Name = ""ashok"".
"no terminator found after TERMINATED and ENCLOSED field" is the error
that i am getting for that record.
Since data itself has double quotes in it. So there is a problem in
identifying the column.
Can any one help me in solving this issue without changing the data i
need to load the same.
Regards,
Ashok
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--------------------------------------------------------------------------------------------------------------------
'This email and any files transmitted with it are confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email in error please notify the system manager. Please
note that any views or opinions presented in this email are solely those of the author and do not necessarily
represent those of the Council. Finally, the recipient should check this email and any attachments for the presence
of viruses. The Council accepts no liability for any damage caused by any virus transmitted by this email.'
'Mae'r e-bost yma ag unrhyw ffeiliau trosglwyddwyd ynddi yn gyfrinachol ar gyfer defnydd yr unigolyn neu'r sefydliad
cyfeiriwyd ati yn unig. Os ydych wedi derbyn yr e-bost yma mewn camgymeriad rhowch wybod i reolwr eich system.
Nodwch taw unrhyw sylwadau neu farn soniwyd amdanynt yn yr e-bost yma ydi sylwadau a barn yr awdur ac nid yn
angenrheidiol yn cynrychioli rhai'r Cyngor. I orffen, dylid y person sy'n derbyn yr e-bost sicrhau nad oes firws
ynddi nac mewn unrhyw ddogfen sydd ynghlwm i'r e-bost. Nid yw'r Cyngor yn derbyn unrhyw gyfrifoldeb am unrhyw ddifrod
achoswyd gan unrhyw firws trosglwyddwyd gan yr e-bost yma.'
Oracle LazyDBA home page