2 Replies Latest reply on Feb 23, 2015 7:13 AM by MW Design

    ZIP-code grouping

    niklaså19494203

      I'm merging a database in to InDesign containing a 5-digit ZIP-code. The five digits are in a row (12345) but I want them grouped like 123 45, with a space between the third and fourth digit. Is there a way to do this automaticly?

        • 1. Re: ZIP-code grouping
          Colin Flashman Adobe Community Professional

          When you say "merging a database in to InDesign", are you using the Data Merge feature of InDesign, or are you placing the Excel text into InDesign using either File/Place; or cutting and pasting from Excel to InDesign. If placing/pasting, I would use a GREP search. If using Data Merge, merge to a new document and again use a GREP based solution, unless you are merging directly to a PDF, and in that case I'm not sure how to do this besides manipulating the original data.

          • 2. Re: ZIP-code grouping
            MW Design Level 4

            You can also split the zipcode in Excel using a string function and make it two fields in ID's merge. But post-merge to a new ID document, you can also use a grep find/change as Colin suggests.

             

            Mike