Visual Basic.Net - CSV file formatting
Posted on 2010-03-28
My program needs to create a CSV file.
I'm having issues writing this string to a text file that will meet CSV standards. In particular, my program is not creating a file that can be opened with MS Excel and have all the data in the correct column. My format is thrown out of skew when I encounter stirngs that have the delimiter (comma), double quotes, line feeds, and carriage returns in them.
I'm currently reading this material data into a vb.net DataTable and then attempting to write each record from this DataTable to a csv file.
Anyone have a function that can format a string to the correct format for MS Excel to align the columns correctly?