Illustrator Variable data - ignore blank cells in the csv

Community Beginner ,
Nov 08, 2019 Nov 08, 2019

Copy link to clipboard

Copied

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.

TOPICS
Feature request , How to , Import and export , Print and publish

Views

893

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jan 09, 2020 Jan 09, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 19, 2020 Jun 19, 2020

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 06, 2022 Feb 06, 2022

Copy link to clipboard

Copied

Quick fix for anyone still searching,

copy an empty character from emptycharacter.com

paste that in the blank cell. You're welcome

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 06, 2022 May 06, 2022

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
May 06, 2022 May 06, 2022

Copy link to clipboard

Copied

LATEST

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.

 

Anshul_Saini_1-1651871733199.png

 

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines