I’m trying to import some SAP SLT table data and hitting what looks like escape character \ to present a quote that isn't the surrounding quotes. This example should load as Monitors 22". I can get it in for what I'm doing now, and this is just for analysis, but I'm curious if there is a method other than editing the source or leaving the quotes and post-scrub them out.
"Snoop D.","Monitors 22"","",
So do you mean that your export file looks like:
"Snoop D.","Monitors 22\"","",
and you want Toad to process the \" as just "?
Unfortunately, the text file parser for Toad's Import Table Data feature does not support escape characters. I could add that feature if it's needed. The only workaround I can think of (if you have control over the format of the export file) is: Don't quote your strings and if necessary, use something besides a comma for the delimiter (maybe a tab?). Or export to excel instead of text (again, without quotes)
-John