Variables does not import Quotation Mark symbols during Load Variable Library
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.
