When outputting ZP info into a csv file, I use "," to isolate each value because , without the apostrophes will break every comma inside the value. Like an article with commas, will be broken at every single turn.
But when there are apostrophes inside the value, like this:
"{-Variable.producturl-}","{-Variable.movietitle-}","{-Variable.reviewtitle-}","{-Variable.review-}","http://{-Variable.tumblrpic-}","{-Variable.pinterestpic-}","{-Variable.youtubevid-}"
"Wer nur ein Menschenleben rettet, rettet die ganze Welt!",
it sees this:
"","
it seems to interpret it as a line break and it jumps onto the next row. Plus, once it's on the next row, the commas inside the value break the values, so it's very messy.
I don't understand why this happens because I thought I was successfully isolating the values with commas, and the apostrophes were protecting the value breaks from the commas inside the values. But no.
But when there are apostrophes inside the value, like this:
"{-Variable.producturl-}","{-Variable.movietitle-}","{-Variable.reviewtitle-}","{-Variable.review-}","http://{-Variable.tumblrpic-}","{-Variable.pinterestpic-}","{-Variable.youtubevid-}"
"Wer nur ein Menschenleben rettet, rettet die ganze Welt!",
it sees this:
"","
it seems to interpret it as a line break and it jumps onto the next row. Plus, once it's on the next row, the commas inside the value break the values, so it's very messy.
I don't understand why this happens because I thought I was successfully isolating the values with commas, and the apostrophes were protecting the value breaks from the commas inside the values. But no.