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.
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.
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
Please sign in to leave a comment.