Export Table to CSV, with commas not newlines

Question

I have a function f[a]. I run it through Table to generate a huge list of values for later use in a C program as a lookup table. I want to export this to CSV so I can copy/paste it into my code editor and quickly turn it into a C array (all I'd have to do is wrap it in curly braces and give it a name):

Export["myfile.csv", Table[ f[a], {a, 0, 6} ], "CSV" ];

What I want is this:

0, 1, 2, 3, 4, 5, 6

and so on, but I end up with this:

0
1
2
3
4
5
6

Each entry is on a new line. What simple, obvious thing have I missed?

Thanks!

Answer 1

You could export using the more general "Table" format and specify the line separators. For example:

Export["myfile.csv", Table[f[a], {a, 0, 6}], "Table", "LineSeparators" -> ", "]

FilePrint["myfile.csv"]
(* Returns: 
f[0], f[1], f[2], f[3], f[4], f[5], f[6]
*)

You might also need to specify the "FieldSeparators" option, it's default for the "Table" format is "\t".

Answer 2

If your export object is a single list, you can avoid modifying its elements, and just wrap it in List:

Export["myfile.csv", List @ Table[f[a], {a, 0, 6}]]