Extra quotes added to text cells in .tsv export in Numbers
I am using Apple Numbers to annotate some text (one word in each cell). When I export the file as a .tsv file, quotes are added to some cells (e.g. when there are quotes within the cell's text content). Ideally I would like to export the data without these added quotes, rather than have to post-process the file to remove them.
However, the biggest problem is that in some cases, a single quote-mark is added either at the beginning of the cell, and this cannot be detected with post-processing rules.
Here are 2 examples:
Content of cell: "⎵
Exported content: "⎵"
Content of cell: tell'ye"caster"
Exported content: "tell'ye""caster"
I have even tried converting the cell types to "automatic" and using formulae such as textjoin (and escaping the real quotes), but that produces the same result. Is there any way of avoiding this? I cannot find any way of exporting the data correctly.
Thank you in advance!