Saving a file to CSV in C#/ASP.NET with different encodings

Question

I do the following in my app:

 File.WriteAllText(OutPutFileName + InPutTitle + ".csv", OutputText, Encoding.UTF8);

 //outputText is a string of data separated by commas with line breaks

When I output with Encoding UTF8 and open the csv in Excel, each data point between commas is in each correct cell. But when I switch to Unicode or UTF32, the commas show up in excel and the data is on one long line.

How do I fix this while having encoding at UTF32 (I want this because I have certain chars that need displaying that don't come out in UTF8).

does that happen with any kind of delimiter , or only commas? — Saher Ahwal
– Saher Ahwal, Commented Aug 26, 2011 at 19:08
not sure, the app is too big to change delimiters since thats in the sql assembly generation — cdub
– cdub, Commented Aug 26, 2011 at 19:11

Jon Martin · Accepted Answer · 2011-08-26 19:08:43Z

2

You might have to split that up into several lines. Use encoding UTF8 for the commas and other basic stuff, and only use UTF32 for what is needed.

answered Aug 26, 2011 at 19:08

Jon Martin

3,4205 gold badges32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cdub Over a year ago

oh that kinda sucks but makes sense

cdub Over a year ago

yeah it messes up if you alter encodings, so thats a no go

Collectives™ on Stack Overflow

Saving a file to CSV in C#/ASP.NET with different encodings

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related