Thanks Neil,
That does address the first question very nicely!
As for the follow-up question, in the example below, the output has two set of double quotes like this: text with""quoted text"" . The goal would be to have only one set of double quotes, like this: text with "quoted text"
row0 = {"h1", "h2", "h3", "h4", "h5", "h6"};
row1 = {"", "", "a1", 1.01, "", ""};
row2 = {"", "", "b1", 2.02, "", "text with \"quoted text\" "};
row3 = {"", "", "c1", 3.03, "", ""};
data = {row0, row1, row2, row3};
Export["data.csv", data, "TextDelimiters" -> ""];
Output is the following
h1,h2,h3,h4,h5,h6
,,a1,1.01,,
,,b1,2.02,,text with ""quoted text""
,,c1,3.03,,
, just need to change the "" to "