I hate csv files RRS feed

  • Question

  • 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