I didn't want to do this via CF as that would entail looping over EVERY row and doing an individual update BACK to the database of every row. Ick ick ick.
I posted a 'solved' post with the solution I came up with - let the DB do the work :) At 04:34 PM 3/14/2003 -0500, you wrote: >Is this straight TSSQL or are you doing CF? Can you do a replace() on the >double-quotes in each string/substring? I just finished a similar utility, >but I specified a tab-delimited text file as the import, implemented a >customization of the BufferedReader java class I found on macromedia.com; I >replace bad characters, trim and test for empty strings, then build a >dynamic built sql string that inserts only the fields that aren't "empty" >and executed the query using PreserveSingleQuotes(). I know what you're >going through: that's why I specified tab-delimited; comma-delimited files >are notoriously different accg to any program/programmer who builds them -- >sometimes with double-quotes around every text value, sometimes >single-quotes, sometimes only around values that contain interior commas. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
