Illustrator Variable data - ignore blank cells in the csv

[KevinB703]

I'm looking and looking for a solution to have variable printing ignore a blank cell in my file.  I've tried adding a space into the cell, as well as every combination of " ", ' ', " [space] –– no luck.  I am now reading that you shouldn't have blank cells but is there truly no workaround?

To create the csv I'm working in Google Sheets if that matters – I've also edited the file using text editor so I don't believe it should.

[Lukas Engqvist]

When doing variable data you may need to some cleaning in your data before merging. One option can be to merge the data from several fields to preprocess the data. There is also a script for variable data in illustrator, don't know if that opens a solution. See Adobe Illustrator Variable Data Importer - YouTubehttps://www.youtube.com › watch

[sbrown.terarecon]

Make sure the text objects in your template are empty.  Otherwise, they will switch back to the original text when Illustrator encounters an empty field in the data set.

[Jordan23020942r3ec]

Quick fix for anyone still searching,

copy an empty character from emptycharacter.com

paste that in the blank cell. You're welcome

[default4idfpndkfegd]

This was a good idea, but I tried it for mine and it doesn't work. I get a character that looks like a box with an X thru it.

[Anshul_Saini]

Hi @default4idfpndkfegd,

We are sorry to hear about the trouble. If you are getting a character like shown in the following screenshot, then I would like to inform you that it is a known issue while copy-pasting, and we are currently investigating it.

You may upvote this UserVoice (https://illustrator.uservoice.com/forums/601447-illustrator-desktop-bugs/suggestions/43954350-why-do...) and add your comment there.

By doing this, you will get an update when it is fixed.

If this is not the issue you are facing, then I would request you to share a few details like:

• OS & version of Illustratoror
• A small video demonstrating the issue
• Download link to the sample file
• Is this happening with all the files?

We will be looking forward to your response.

Thanks & Regards,

Anshul Saini