Skip to main content
K
KevinB703
Participant
November 8, 2019
Answered

Illustrator Variable data - ignore blank cells in the csv

  • November 8, 2019
  • 6 replies
  • 6195 views

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.

    Correct answer templatemaker-nl

    This works in my case, great.

    Instead of the website you mention, since we are in Illustrator anyway, we can obtain the character by entering it in a text object through

    Illustrator --> Type --> Insert WhiteSpace Character --> Em Space

     

    and then copy-ing it.

    6 replies

    J
    Javier25574794nbdy
    Participant
    August 20, 2023

    I had the same question and was never able to solve it even after following the advice shared here. I simply turned to InDesign because it alreadu has an "ignore blank data fields" options built into its data merge funcitonality.

     

    D
    defaultqnjfvgoc6yay
    Participant
    August 19, 2022

    I had the same issue - worked round it by adding an additional visibility column in the .csv

     

    Eg.

    Column_A,Column_A_visible

    Data 1,TRUE

    ,FALSE

    Data 2,TRUE

     

    And then mapped 'Make visibility dynamic' to this field for the columns that contain blanks.

      Arisay2025
      Arisay2025
      Participant
      February 17, 2023

      I am having the same problem and I am not sure where to enter 

      Column_A,Column_A_visible

      Data 1,TRUE

      ,FALSE

      Data 2,TRUE

      Any help is much appreciated as I am not a coder.

      C
      Christoph286895045j4q
      Participant
      March 3, 2023

      Add an extra column in your spreadsheet and name it "#visible" (the "#" is important as it later defines if it's visible or not). Below you add the funktion "=not(ISBLANK(C2))" so when C2 is blank you get a FALSE and if it's not blank you get a TRUE. 

       

      In Illustrator you make the desired object "make text dynamic" and also "make visibility dynamic". Then you replace the reference name "Variable1" next to the eye-symbol with "visible" as that's the actual name of your added column "#visible". You may need to reload the csv-file.

        aTomician
        aTomician
        Inspiring
        May 27, 2022

        Same issue here.  I had a idea that I could put loads of spaces followed by a character that would be outside of the textbox so the textbox looked blank... however just found out that Illustrator removes preceding and trailing whitespace...  which is odd and unnecessary really.

         

        Edit: just been doing some more research into Illy Variables.  Conclusion: What a frickin shite system.  It literally does nothing useful, unless you're prepared to put loads of time into it, in which case you're better off creating a Word mailmerge, InDesign template or just dong it manually.  It would be quicker to write a html / Javascript webpage to run through the data and save as PDF then it would be to do it in Illy.

        Regards, aTomician
        J
        Jordan23020942r3ec
        Participant
        February 6, 2022

        Quick fix for anyone still searching,

        copy an empty character from emptycharacter.com

        paste that in the blank cell. You're welcome

        D
        default4idfpndkfegd
        Participant
        May 6, 2022

        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
        Community Manager
        Anshul_SainiCommunity Manager
        Community Manager
        May 6, 2022

        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-does-the-envelope-sign-appear-at-the-end-of-co) 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

        S
        sbrown.terarecon
        Participant
        June 19, 2020

        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.

        aTomician
        aTomician
        Inspiring
        May 27, 2022

        That isn't what happened to me, I have 5 text boxes, corresponding to 5 columns in a CSV.  For each row, only one of any of the 5 columns contain a value.

         

        When I cycle through the datasets, the text box only updates for a valid value, and keeps the previous values if they're blank, so my my text boxes look like this when I cycle through the datasets:

         

        First row has "A" in col 3:

        [   ]  [   ] [ A ]  [   ] [   ]

         

        Second row has "B" in col 4:

        [   ]  [   ] [ A ]  [ B ] [   ]

         

        Third row has "C" in col1:

        [ C ]  [   ] [ A ]  [ B ] [   ]

         

        Fourth row has "D" in col5

        [ C ]  [   ] [ A ]  [ B ] [ D ]

        Regards, aTomician
        Lukas Engqvist
        Community Expert
        Lukas EngqvistCommunity Expert
        Community Expert
        January 9, 2020

        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

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices