Copy link to clipboard
Copied
I've googled for a solution many times over years so now I've figured it out I thought I'd share.
When using a CSV file in Datamerge, all characters like ' & !£$%^&*) come out as weird text like "‚äô" so usually I reluctantly find and replace these odd characters with intended ones but one always slips to print and I don't like this unsolved hacky solution. Now I've found a way!
Here's what works for me:
This works for me using Google Sheets, Text Edit (MAC) and Adobe Indesign CC 2015 on iMac El Capitan 10.11.6
Comment if this works for you!
Copy link to clipboard
Copied
what does the .csv file look like? are there empty values with commas after them. hidden merged cells will create extra spaces in the .csv file. using text wragler you can quickly clean up your .csv file.
a clean .csv file is important from my past experiences.
ex:
title;
entry,
entry,
entry.
....
Copy link to clipboard
Copied
My issue wasn't spaces but the conversion of intentional characters, for example it replaces apostrophes "'" with "‚äô" and this happens for most symbols I want to use in my text.
The method I've posted uses TSV instead of CSV, and then TXT.
Works for me!
Copy link to clipboard
Copied
Hi.
After a long winter, I've finally found a way. I'm using Apple Numbers and decided to test all .CSV encodings. The only one that worked was "Western Mac OS Roman".
The only extra step was to convert ";" to "," because my Numbers export with ";" (I can't find a way to change it).
Hope it helps.
Luiz
Copy link to clipboard
Copied
This worked for me, thank you!