Copy link to clipboard
Copied
Hi,
I have an Excel file to Data Merge, and I've converted it into a CSV for InDesign.
In my Excel file, I have Names followed by a Class Year. For example, "'Mr. John Smith '82", but when InDesign reads the apostrophe, it's a Forwards one instead of a Backwards one.
I would change the apostrophe through Glyphs with a find and replace, however, I have more than a hundred rows in my CSV, and the rest of the normal apostrophes in the rest of the document would change.
Is there a faster way to replace/change these apostrophes?
In your preferences, the checkbox asking about typographers quote will make a difference here.
I've just replicated your situation. When checked on, the line comes through with a single left quote. If i turn the checkbox off and then toggle preview on and off, it goes to a straight quote.
That said, if you want typographers quotes elsewhere BUT in this instance you need a single right quote, you will need to actually copy that glyph into Excel. This can be done from your contextual menus when y
...Copy link to clipboard
Copied
Here's a picture in reference to what I'm asking help on:
Copy link to clipboard
Copied
In your preferences, the checkbox asking about typographers quote will make a difference here.
I've just replicated your situation. When checked on, the line comes through with a single left quote. If i turn the checkbox off and then toggle preview on and off, it goes to a straight quote.
That said, if you want typographers quotes elsewhere BUT in this instance you need a single right quote, you will need to actually copy that glyph into Excel. This can be done from your contextual menus when you have a blinking text cursor in a textframe.
 From here with the new single right quotation mark inserted, copy the character and paste it into the appropriate place in Excel.
When a csv is now exported, selected as a data merge source (with the typographers quotes on in preferences) this is what I end up with:
 The other way to do this is have two fields - one with the person's name, the next with the year. In your data merge file in indesign, you would have a line of text that looks like this:
<<name>> ’<<year>>
This way InDesign can control the formatting of the quote from here without relying on Excel parsing the data to a text only format which is then parsed again via InDesign's data merge tool.
Copy link to clipboard
Copied
Hi Colin,
Thank you for your response.
(However, I had a few fields with multiple names & graduation years in them, and had to manually fix them.
I thought I could split them into 4 fields, <<name1>> '<<year1>> and <<name2>> '<<year2>>, "Mr. John Smith '82 and Mrs. Jane Smith '82." Unfortunately, I'd have to manually delete an extra single right quote for lines that do not have two names in the first field. Thankfully there were not that many double names. Is there a way to solve this issue? I will have many more documents in the future.)
Copy link to clipboard
Copied
Copy link to clipboard
Copied
you could remove the language via GREP character style for the missing letter apostrophe.