Skip to main content
Participant
June 17, 2021
Question

Variables does not import Quotation Mark symbols during Load Variable Library

  • June 17, 2021
  • 1 reply
  • 3017 views

Illustrator 25.2.3 on Windows 10 Pro 10.0.19042 Build 19042, x64-based PC

 

I have a Variable Library where one of the variables for every single Data Set is a different quotation. It's crucial that the text is presented as a quote using quotation marks. However, when loading using Load Variable Library the quotation marks are removed during the process.

 

I've tried saving as each of the four styles of CSV that Microsoft Excel allows with no success. Also tried a Copy Paste into Google Sheets and then saving from there as a CSV without success. Excel would not allow me to save as XML "because the workbook does not contain any XML mappings".

 

Also tried replacing the quotation marks with Unicode symbols using «» but those did not translate to the "" symbol and just showed up as «». Tried going into Document Setup->Type to change Double Quotes back and forth from «» to "" but it doesn't refresh text that's already loaded. Not sure if there are other methods to trick Illustrator into keeping the "" symbol during Load Variable Library. Find and Replace doesn't work either, as it only works within the current Data Set and you have to click Update Data Set every time you move to the next Data Set.

 

Frustrating to be so close and yet so far. Manually typing quotation marks to the front and back of that variable on every single Data Set and then having to manually click Update Data Set is probably more time consuming than doing a manual Copy-Paste. But then I would have to manually Copy-Paste all the other variables that were working properly, so I'm essentially stuck between two bad methods. Not sure if there are other methods to get this to work or if I need to go with a third-party solution that's better than Variables.

This topic has been closed for replies.

1 reply

rcraighead
Legend
June 18, 2021

Have you tried "escaping" the character, as in Regex?

\"

Participant
June 18, 2021

I am not familiar with that method but would be glad to learn more and try it out.

rcraighead
Legend
June 18, 2021

Just try adding a \ before each double quote in your text before uploading the library. This should tell JavaScript to read the subsequent character literally instead of seeing it as defining a string. It may also be necessary to add a double quote BEFORE the \.

 

Edit: Of course, search and replace can make that an easy task in Excel or Text Editor.