Quiz generator: How do I include a comma in exported CSV question?

Michael.P.245

Good morning everyone! I need your help, please. I have reached a dead end in my research and don’t know how to answer my math instructor with the following question. She asked:

I have been using the (Brightspace) Question generator. I notice that if the question has a comma (,) when it downloads to excel csv, the question is not completed. As you know I have a lot of commas in my exam. Any advice on this?

Does anyone know the answer? Please let me know.

Thank you, Michael

Janet.W.813

Hi Michael,

I have not tested this, but have you tried double quotes around the commas? I found this in Stack Overflow's documentation:

Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes.

So, to have values foo and bar,baz, you do this:

foo,"bar,baz"

Hope that works!