csv or the final merged InDesign file, if you still hapen to have double or tripple word spaces. Sounds complex, but it is pretty fast and easy once you get the hang of it.ĮDIT: Do a find/replace for multiple spaces and convert them to single spaces in the. In InDesign, you select a text file as part of the Data Merge setup process (called a data source file) with a column representing the relative path or name of the image file. Then you can just datamerge this single column. InDesign offers a Data Merge feature that can be used to import not just text, but images as well. Then delete the original colum A/B/C as the new column D has the merged title/name. When you put a field on a Master Page, you get the result youre seeing. The Data Merge panel now shows your column headings Notice how the text fields have a text icon and the image fields have an image icon. Click the menu button at the top right, and choose Select Data Source Find and select the CSV in your Links folder. One can then copy the formula and paste special (formula only) onto all the records (row 2 to 1300 etc). Data Merge works only with document pages. Switch to InDesign and select Window > Utilities > Data Merge to open the Data Merge panel. This formula will put a word space between each column. From here, select the field names to be used as filenames from the left hand column, and add them using the add button. Select the fields to use for the filenames. If exporting to PDF, make sure to select a PDF Export Setting from the Select a PDF Export Preset dropdown field. (Presuming that A1 is the title and B1 is the given name and C1 is the family name). When performing a data merge in InDesign, is there a way to conditionally include a space between fields Something like as follows: <<Title> conditional space here<<Name> Not all records have a <<Title> and Remove blank lines for empty fields is checked. Select the export format PDF or InDesign.Use the formula to combine row 1, column A/B/C into the newly inserted working column. So insert a new column to work in (say column D). In Excel/OpenOffice/NeoOffice the formula to merge three columns together is as follows: Another way that I have dealt with this is to combine the title and name fields in the spreadsheet, before doing the data merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |