-
Problem translating dbl quotes with sql loader
I have a data file that has intermittent double quotation marks in it that I want to translate to something else, like a "-". I haver used the sqlldr and the TRANSLATE command to convert other values, but sqlldr seems to problem with the ".
Here is the command that I am using
WELL_NAME "translate(:WELL_NAME,'"','-')",
This is the error:
SQL*Loader-350 Syntax error at line 25.
Expecting ",' or ")", found ",".
WELL_NAME "translate(:WELL_NAME,'"','-')",
I have tried escaping the " with a \, but that did not work either.
Can anyone help?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|