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: 147
csv
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