I hate csv files

• Question

• 

  

  0

  Sign in to vote

  I am trying to use Regex to check for extra commas in a .csv file.
  I import the csv file and read it line by line using the comma as a delimiter. When a comma is included in the data quotes are placed around that cell. I need to get those stupid quotes and that damn comma out of the values. (i.e.: 123,346,”7,89” needs to be changed to 123,456,789) Is there some trick to this?

  ---

  .Net Developer

  Friday, October 23, 2009 1:08 PM