5 Replies Latest reply on Oct 15, 2009 1:19 PM by AEH

    removing blank lines in a calculated field

    AEH

      Title

      removing blank lines in a calculated field

      Post

       In FM Pro 9, we have a calculation to produce the contact info for each person:

       

      TO_PEEP_tblNames::MailName & ¶ &
      TO_PEEP_jctAddresses::MailAddress1 & ¶ &
      TO_PEEP_jctAddresses::MailAddress2 & ¶ &
      TO_PEEP_jctAddresses::MailAddress3 & ¶ &
      TO_PEEP_jctAddresses::MailAddress4 & ¶ &
      TO_PEEP_jctAddresses::MailAddress5  & ¶ &
      "Email: " &  TO_PEEP_jctEmailPrimary::EmailAddress & ¶ &
      "Cell: " &  TO_PEEP_jctPhoneType2:: PhoneNumber & ¶ &
      "Home: " &  TO_PEEP_jctPhoneType1:: PhoneNumber & ¶ &
      "Work: " &  TO_PEEP_jctPhoneType3:: PhoneNumber

       

      Two questions:

       

      1) Often some of the MailAddress fields are empty.  How do we eliminate the blank lines which now appear?

       

      2) If the person does not have all 3 types of phone numbers, is there a way to eliminate both the blank field AND the label for that field (cell/home/work)?

       

      AEH