I have an CSV file with info for about 82 different Business cards. The CSV file has 5 possible different phone numbers for each card with separate columns for each phone number. (Ex. Office, Mobile, Home Fax, BP Fax, KB Office, KB Fax)

The problem is some cards will have only 1 phone number, but they can have up to 4 numbers per card. Keep in mind the phone number are all listed on the same line.

The business card style has this " | ", as the separator for the phone numbers. How do I get the " | " to NOT show up in the front of the first phone number if the first phone number is NOT within the first column in the CSV file? (If first phone number column in CSV is blank?)

Here is what my text box looks like in InDesign: (all on one line)

«empty»Office: «OfficePhone» | Mobile: «CellPhone» | Home Fax: «fax» | BP Fax: «BPFaxNumber» | KB Office: «KBPhoneNo» | KB Fax: «KBFaxNo»

  • This is for creating business cards within InDesign. – Ann Strouse Apr 20 '16 at 17:33
  • Is your problem essentially the same as in this question? – Cai Apr 23 '16 at 15:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.