Which tools and programming libraries are you aware of that can help accelerate CSV manual correction process when column separator characters are encountered within data elements?
I'm currently not able to correct the generation of source CSV files, such as adding quote delimiters. Manual verification is always required to certify that corrections are properly made.
In my case I currently need to run a portable solution on Win32 (i.e. doesn't require administration permissions) and open source would be preferable. Any language is a possibility. Destination is to a SQL Server 2008 instance with very limited permissions (BULK INSERT, OPEN ROWSET and such are not allowed). DTS/SSIS are also not available, neither is Visual Studio. The current method is opening up Excel, filter non-blanks on the last column, correct those filtered out rows, and then export to SQL Server via bcp or MS Access.