When you have fields terminated and optionally enclosed, you should be able to have the enclosure characters within the data by doubling them.
So if I have fields terminated by '|' optionally enclosed by '"' and my data has a double quote in it, I can get SQL Loader to take it by replacing the double quote with two double quotes.
But this doesn't always work. For some reason the following string gets the error "no terminator found after TERMINATED and ENCLOSED field"
Apparently having the double quote immediately after an asterisk makes SQL Loader not see the second double quote. If I edit it and remove the two double quotes it loads OK. Also if I change the string to
Moving the double quote away from the asterisk it loads OK.
Anybody encounter this problem before?
Oracle version is 220.127.116.11.0
OS is Windows 6.1.7601
I can't remove the "optionally enclosed by" clause because we're getting the data from another system. Fortunately this is test data and this particular combination of characters is unlikely to occur in production data.