#INDESIGN DATA MERGE BLANK HOW TO#

But I don't know what they are or how to get rid of them (they are NOT there if Preview is turned off). While in the Merged Document, it seems to take several left arror or right arrow clicks to get thru them, as if they are really there. Open your InDesign document and the Data Merge panel via Window > Utilities > Data Merge > Select Data Source. There's a soft line break in there, on top of the '::' hidden character(s) icon. I don't really know what the two little ::'s are (they are light blue, like hidden characters). Sometimes there are only 2 items we list in the table. The data merge populates the rows and produces individual PDF’s. The InDesign template has a table with 5 rows and 6 columns listing items for purchase. Where the empty field is supposed to be looks like this:Ĭontent Placement options have 'remove blank lines for empty fields'. We have an Indesign template that we use to generate fillable PDF’s from a data file. The preview looks just like the resulting merged document. Hey Hive mind, I am really struggling to pull the data merge document into indesign The first two values show fine and then it produces blank values I have attached the files here if anyone can help I was thinking the excel sheet formatting is wrong as its data pulled from a form https://dri. When I look at the characters inside the csv file, I see consecutive commas for the empty Address2 field (that's really empty, right?). Preview and generating the Merged Document works fine, EXCEPT that the optional Address2 and Country fields that should not be there when blank are always there. The InDesign document is where you design static page elements and establish data placeholders in preparation for the merge. There are two things you need for an InDesign data merge: an InDesign document, and a data source file. I've deleted the frame and have re-done it from scratch. Let’s take a high-level look at that process. csv file set as Ascii, the CR end of line, it does not seem to make a difference.

#INDESIGN DATA MERGE BLANK PC#

My csv file is: UTF-8 Unicode (with BOM) text, with CRLF line terminators, and I've set UTF-8, PC as the datasource (PC generates both cr & lf line ends). I am struggling with someting like this too, and can't explain it.

Indesign data merge blank