C# download csv file with commas

As of right now I am creating different parsers for each feed structure and pushing the common data into a class. My understanding of the FileHelpers utility would be that I had to make a new Class file for each and every feed, kinda defeats the purpose of what I am doing.

It forces us to define a class, this time with a FieldIndex attributes. As mentioned earlier I am reading all kinds of files, with different field indexes and different fields all together. Sometimes a solution is not presented on a plate. You can download the code that I linked to and see how they do the part that you are having the problem with.

Whats the larger context for doing this parsing? Hi, I think it is OK to use Regular Expression to split on the commas that aren't inside a double quote. I made an example, please check whether there is any difference between yours:.

I was just wondering if there was. Just because a guy can make things work doesnt always mean its the best way, Right? And, some files can be read line by line where as others must be read in their entirety and split up. The content you requested has been removed. Ask a question. Quick access. Search related threads. Collectives on Stack Overflow. Learn more. Asked 3 years, 3 months ago. Active 1 year, 7 months ago. Viewed 5k times. Below is my CSV Structure have just taken header row and first data row.

ReadAllLines csvFile. Split separators. ToList ; headerValues. Skip 1. Improve this question. Notify me of new posts via email. For example, if we have: John Smith jsmith example. How does Excel handle CSV files? After a few iterations of saving CSV files in Excel and opening them in Notepad I observed two things: Firstly, if a cell contains a comma, Excel adds quotation marks at the beginning and at the end of a cell.

Secondly, if this quoted cell contains quotations marks inside, Excel doubles them. ToString , string. ToString return true; if cell. Write ; File. WriteAllText "file. IsNullOrEmpty result. ToArray ; Array. Length return null; if line[i]!

So user expects that there will be a single quote in a result cell. We have fully functional CsvReader. ReadAllText "file. So if you open a UTF-8 file, all you get is mojibake.

Summary When I was getting down to this task, it looked like something quite easy. Uncategorized Share this: Twitter Facebook.

Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Follow Following. Growl of Owl. Sign me up. Already have a WordPress. Imports System. When the Export button is clicked, the following event handler is executed. A DataTable is populated with records from the Customers table. Then a loop is executed over the Columns and Rows of the DataTable and a comma separated delimited string is generated.

Finally comma separated delimited string is written to the Response which initiates the File download. ConnectionStrings[ "constr" ]. Fill dt ;. Clear ;. Write csv ;. Flush ;. End ;. ConnectionStrings "constr". Using con As New SqlConnection constr.