(In other words, this dialog box doesn’t fix it retroactively. If you’ve already merged your document, you’ll have to regenerate a new merged document. Then you can do another find/replace within InDesign, to add the new paragraph characters into the text and establish the address in two lines as desired. Fortunately, there’s a simple fix: Before you generate the merge, select Content Placement Options from the Data Merge panel menu and turn on the Remove Blank Lines for Empty Fields checkbox. I did a check and NotePad can do a find/replace with that character.
An option could be to do a find/replace within NotePad to switch out instances of that character with something else (like the '' string we used), prior to merging the data in InDesign. Can't see it in Excel, but it's visible when opening the csv file in a text editor like Notepad. using a spreadsheet application, such as Microsoft Excel, or any text editor. I tried to recreate your situation and I get the same sort of 'square-like' character between the lines within a single cell. Thanks to InDesign's Data Merge, you can make the impossible possible. It's not the ideal solution, but its workable until I find a better way to make use of InDesign's merge features for this situation.Īs for your does appear to be the similar to mine. Open your InDesign document and the Data Merge panel via Window > Utilities > Data Merge > Select Data Source. Share Improve this answer Follow answered at 12:49 Lucian 28. By default, Data Merge will only work with a specific number of table rows, and does not create as many table rows as needed. Then once I did a merge, I replaced each instance of '' with a paragraph break '^p'. This is quite technical and not possible using the built-in Data Merge logic. We revised the data population process so that, as the information is populated from the application into an Excel file, those line breaks were translated into a string '' instead. The character that represented the new line in the application (looked like a square) was not translating correctly into InDesign as it was merged, and each of those 'square-like' characters was recognized by InDesign as the start of a new record instead, creating all sorts of havoc. My original problem started with the fact that the data in a field was either intended for bullet point or paragraph form. I was able to find a work around for my problem.
0 kommentar(er)
