Troubleshooting: How to fix "Remove Blank Lines for Empty Fields" in InDesign Data Merge

I'm working on a card design that has multiple variables within the same text field. Each variable is its own paragraph with its own Paragraph Style.

Original InDesign Document

It's rare that every card has content for each variable ABC though. Usually it's a mix, like AC, AB, or BC. The issue is that when you delete empty lines, sometimes the remaining paragraph gets re-assigned the deleted paragraph's style. Compound this over a whole document and you can see why it's a pain in the butt.


Here's a video explaining the situation:


Here's my solution:
To reliably remove blank lines from a merged document, first do NOT activate "Remove Blank Lines for Empty Fields" in your Content Placement Options. It's often too buggy to be reliable, except in the most simple cases where all of the paragraphs have the same style anyway.

Then Create Merged Document as you normally would. The resulting document will have a lot of blank lines because of the empty fields. Here's what you do about that:

In your merged document, run two Find/Replace searches.

First, you want to delete the strange white space characters introduced by Data Merge. You have to clear these out first since they get in the way of a traditional find/replace for empty paragraphs. In your Find/Change menu, make sure you are in the Text tab and run this search:
Find what: <FEFF>
Change To: Leave this completely empty since we want to delete these empty spaces.
Search: Document
Click "Change All"

Next, you can now delete empty lines. In your Find/Change menu, make sure you are in the GREP tab and run this search:
Find what: ^\s+
Change To: Leave this completely empty since we want to delete these empty spaces.
Search: Document
Click "Change All"

That should resolve any empty spaces you might have in your document.
---
BONUS:
If you happen to have an empty space at the end of your text field that hasn't been resolved by the first two steps, here is an optional third step:

In your Find/Change menu, make sure you are in the GREP tab and run this search:


Find what: \s+$
Change To: Leave this completely empty since we want to delete these empty spaces.
Search: Document
Click "Change All"

It's important you only do this search AFTER you've done the first two, but it should work like a charm.

Hope this helps!

Comments

Post a Comment

Popular posts from this blog

5 Graphic Design and Typography Tips for your Card Game

Image
Chris Farrell of Illuminating Games just wrote a thorough critique of card games setting their body text to be so small that they cannot be read at arm's length, let alone across the table. Here's an excerpt, but the whole thing is worth a read for any would-be card game designers out there. (Myself included.) Break out your copy of the base set of Dominion, and look at the Chapel. This has a text box roughly 3.5cm by 4.5cm. It's got a single line of text. That line of text is 1 (one) millimeter high. 1mm! For me, it's only clearly readable at half an arm's length even in the bright light of day. (...) Compare this to a more sane game like Glory to Rome, where the font size is 2-3 times as large (text is 2mm high, keywords 3mm and usually highlighted). I can generally read Glory to Rome cards across the table, and can certainly see the important keywords. To heap insult upon injury, not only does Glory to Rome have far more legible text than Dominion it also has
Read more

Low-High Dice Game

Image
A dice game inspired by the stock market (and playing lots of Martian Dice). Roll a bunch of dice and choose which sets to keep. Choose your strategy wisely! Stuff You Need Two-to-Six PLAYERS A PENCIL and PAPER to keep score Thirteen standard six-sided DICE How to Play The shortest player takes the first turn. On your turn, first roll all thirteen dice. Several dice will have matching results. These are called SETS. (A single die result is a set, too.) You must choose a set to keep. For example, your first roll results are 111124445555 . The sets are four 1 s, one 2 , three 4 s, and four 5 s. After keeping a set of dice, lock them up in a row. This is called the GOOD TRACK. For example,  you could keep the set of four 1 s, one 2 , three 4 s, or four 5 s . You decide to keep the four 1 s and line them up in your good track. After keeping a set, you may end your turn or re-roll the remaining unlocked dice. When you re-roll, immediately set aside any results that ar
Read more

The Thousand-Year Game Design Challenge

Image
UPDATE: The submission period has closed and here are the entries. If you're an entrant, continue sending pics or vids of people playing your game. The first step to a game lasting a thousand years is for people to play it today. UPDATE 2: And here's the winner! To support games designed for longevity – that can be learned, played and shared for hundreds of years – we offer this challenge to any game designers, artists and imaginative people who also share this desire. Challenge Create a game. The game can be of any theme or genre you desire, but there is one restriction: You're creating a "new classic," like Chess, Tag or card games. So, create a game to be enjoyed by generations of players for a thousand years. Prize $1,000 to the winning entrant, to be announced and awarded January 1, 2012. Entry Deadline Entries must be submitted before midnight July August 31st, 2011. ( Update ) Entry Guidelines Enter by posting a comment below with a link
Read more