C#
C#

How to embed quotation marks in output file C

I am using this to write data to a comma delimited text file.
tw.WriteLine("{0,1},{1,1},{2,1},{3,1},{4,1},{5,1},{6,1},{7,1},{8,1},{9,1},{10,1}", dr["Arrest_ID"],dr["Incident"],dr["Arrest_Date"],dr["Arrest_Time"],dr["Age"],dr["Sex"],dr["Race"],dr["Ethnic"],dr["Crime_Location"],dr["ESRI_LOCATION"],dr["Law"]);

Now they are requesting that I enclose the text fields in quotation marks. Is it as simple as "{0,1}"?

LVL 1

rwheeler23Asked: 2018-01-18

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 18

Dustin SaundersDirector of OperationsCommented: 2018-01-18

More or less, you just need to either escape the quotes with \" or do a string literal.

But not 100% sure what class tw (custom or TextWriter?)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 40

NorieAnalyst Assistant Commented: 2018-01-18

Try using \".

Not 100% sure which fields are text so the below adds " around all of them.:)

w.WriteLine("\"{0,1}\",\"{1,1}\",\"{2,1}\",\"{3,1}\",\"{4,1}\",\"{5,1}\",{6,1}\",\"{7,1}\",\"{8,1}\",\"{9,1}\",\"{10,1}\"", dr["Arrest_ID"],dr["Incident"],dr["Arrest_Date"],dr["Arrest_Time"],dr["Age"],dr["Sex"],dr["Race"],dr["Ethnic"],dr["Crime_Location"],dr["ESRI_LOCATION"],dr["Law"]);

Open in new window