InDesign CC latest version Data Merge not removing blank lines

Forum|Forum|7 years ago
September 23, 2018
2 replies
1405 views

I have been having issues with this for months now. It's getting old. My settings attached

data merge

This topic has been closed for replies.

Correct answer Scott Citron

Turns out the data file had some weird hidden characters in it. Once I deleted those characters the merge was perfect.

K

katherinereeceAuthor

Inspiring

Thank you Scott. I tried setting up a new file and used the hard return, but I was still getting the blank spaces. I just went through and manually deleted the lines.

Scott CitronCorrect answer

Legend

Turns out the data file had some weird hidden characters in it. Once I deleted those characters the merge was perfect.

Scott Citron

Legend

Can you post a screen shot of the Data Merge fields? Are they set up on Document page 1, or on a Master page? Or, could you make the file available for download? Would love to try it myself.

You might also want to check out this thread on the same topic:

Re: InDesign CC 2018 Data Merge Blank Lines not removed

K

katherinereeceAuthor

Inspiring

Data merge fields are on page one. I am not using a Master page in this file. Here is the CSV and InDesign unmerged file https://drive.google.com/drive/folders/1az9mHt0OHUPh-I9soCE4EA4fsQZNMaF8?usp=sharing

Scott Citron

Legend

Kathy, I discovered some weird characters in your InDesign file. See screen shot below.

These characters are hard to see because they're crashing into the pilcrows (aka paragraph marks), but as soon as I deleted them the file merged perfectly. I'm sending to send you back the cleansed ID file if you'd like. Just let me know.

Scott

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded