NEW ISSUE (the issue below has been solved)
export to csv/delim has 1 extra blank line!?
how can I avoid this.. the file cannot contain any extra lines.
SOLVED:
I am trying to use the export to delim node...
the problem is I need only certain fields to be quoted, so I pre-formatted all the data, i just need to basically spit it out to a csv.
its erroring because it wants an escape char, but if i put something in there, it comes out in the file.
if I put a quote char, it double quotes...
so i need no field names, comma delim, and thats it. i have added the quotes and formatted everything as needed already.
****SOLUTION****
got it... if anyone needs this...
Leave everything default, but use the same char in the quote as the field delim..
in my case i combined all fields into one field and spit that out... then used | as the field and quote value since its not being used anywhere in the output.. it comes out PERFECTLY!!
side note, combining the fields into one, allowed me to create a footer row and cat to the end of the data before outputting