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. Apr 20, 2016 at 17:33
  • Is your problem essentially the same as in this question?
    – Cai
    Apr 23, 2016 at 15:32


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.