Post by fzghoul on Feb 15, 2021 20:39:56 GMT
Sorry, my skills are pretty rudimentary so I am making some silly errors...
I'm trying to export a freeform text field (among other fields) to CSV. I have to strip out line breaks, so I'm using the replace function. It works, but all the apostrophes ( ' ) are showing as "’" I do not know if this is a characteristic of CSVs or if I'm using the replace function incorrectly. For what it is worth, I also convert another field to text and the apostrophes come over without issue, I am not using the replace function for that field.
Here is the replacement text.
replace(match: "," , replace: ";" , replace(match: "\n" , replace: " * " , to_text(card.rules)))
Bonus question while I'm working on this... rather than write to a file, is there a way for export to append onto an existing file?
Many thanks!
I'm trying to export a freeform text field (among other fields) to CSV. I have to strip out line breaks, so I'm using the replace function. It works, but all the apostrophes ( ' ) are showing as "’" I do not know if this is a characteristic of CSVs or if I'm using the replace function incorrectly. For what it is worth, I also convert another field to text and the apostrophes come over without issue, I am not using the replace function for that field.
Here is the replacement text.
replace(match: "," , replace: ";" , replace(match: "\n" , replace: " * " , to_text(card.rules)))
Bonus question while I'm working on this... rather than write to a file, is there a way for export to append onto an existing file?
Many thanks!
