On Wed, Dec 14, 2011 at 1:18 PM, Elliot Voris <[email protected]> wrote: > Hi, Dan > > Thanks again for your help! I'm still having no luck. As a test measure, I > removed any single-quotes (') from the MARC records before enclosing them in > the format that your script was in: ('<MARC>'), so I'm sure my issue is > something else. > > I'm wondering if PostgreSQL doesn't like the way I put the parenthesis and > single-quotes to begin with. The only method I could figure out to put the > necessary characters in place was using Notepad++. I did a find/replace with > the regular expressions as follows: > > To place the "('" at the beginning, I found the regular expression "^(.*)$" > (no quotes), and replaced with the regex "('\1" (again, no quotes) > To place the "')," at the end, I found the regular expression "^(.*)$" (no > quotes), and replaced with the regex "\1')," (again, no quotes) > > Could that have messed up encoding or something? Is there a better way to add > the necessary parenthesis & single-quotes at the beginning/end of each line?
Elliot: It might be easiest to debug if you could attach a small sample of your import script - say, 10 lines - so that we can see what it actually looks like. Dan
