Removing extra commas in CSV without another data source

Posted by fi-no on Super User See other posts from Super User or by fi-no
Published on 2010-06-14T14:45:34Z Indexed on 2010/06/14 14:53 UTC
Read the original article Hit count: 146

Filed under:

We have a large database with customer addresses that was exported from an SQL database to CSV. In the event that a company has a comma in their name, it (predictably) throws the whole database out of whack.

Unfortunately, there are so many instances of this (and commas in the second address line) that the whole CSV (~100k rows) is a huge mess. The obvious fix is to export the data again in a different, non comma reliant format, but access to that SQL database is more or less impossible at the moment... I've tried a few tools and brainstormed about combining things to fix this, but I figured asking couldn't hurt. Thanks!

© Super User or respective owner

Related posts about csv