3 Replies Latest reply on Jul 7, 2014 3:02 PM by Robert Sinclair

    Data Merge Alternating Bold


      Hello all!


      In trying to tweak an InDesign document, I found that there is a section of text that was generated from an Excel sheet we have that is effectively a list of companies that are separated by dots, alternating in bold and non-bold typeface. Assuming I get the list of companies in a CSV or Excel format and can import the data, what is the means by which I can achieve that algorithm of alternating bold and non-bold text? I was clued that the method used was Data Merge, but none of the scripts InDesign ships with appear to offer that functionality.


      Help is much appreciated! Thank you for your time!




        • 2. Re: Data Merge Alternating Bold
          coltonoscopy Level 1

          Thanks SDesigns; the GREP feature in particular looks like it might work, assuming I can get the data to merge with a separator between each company. That's where I'm having trouble now; I can't seem to be able to merge a particular column from the CSV that has the company names into a paragraph of text within my document, as it only seems to let me merge in the first company name only. Do you know how I can achieve this, and additionally how I can get it to automatically insert any particular separator (as there are hundreds if not thousands of company names, manually typing in the separator could get very tedious)? Attached is a screenshot of what the final text looks like in the document, though it doesn't seem to let me "Update source" on the paragraph, which would make things much easier.Thank you very much for your time and help!




          Screen Shot 2014-07-07 at 5.48.59 PM.png

          • 3. Re: Data Merge Alternating Bold
            Robert Sinclair Level 1

            It sounds like you don't need data merge at all.  Just use "File > Place" to get the data into ID, which should insert as tab-deliminated text.  Then find-and-replace "^p" (if each company is separated by a paragraph break, or "^t" if it is tabbed) with " •^S" and you're set to apply the nested style.  The "^S" after the bullet is a non-breaking space, which you can use to trigger the nested style.