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

Michael.P.245
Michael.P.245 Posts: 6 Analytics Builder Transition
in Higher Ed / Postsecondary

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

· Share on Twitter

Best Answer

  • Janet.W.813
    Janet.W.813 Posts: 60
    Answer ✓

    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!

    · Share on Twitter

Answers

Categories