removing blank lines in a calculated field
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
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)?