AnsweredAssumed Answered

removing blank lines in a calculated field

Question asked by AEH on Oct 15, 2009
Latest reply on Oct 15, 2009 by 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





Outcomes