AnsweredAssumed Answered

Substitution and sliding problem

Question asked by willrollo on Jul 28, 2013
Latest reply on Jul 28, 2013 by willrollo

Title

Substitution and sliding problem

Post

     I am designing a mailmerge type of layout. I have created a few buttons that insert text into the editable field that contains teh merge letter text body. On my preview page, I have a caclulated field that converts this text body and inseterted texts into address/names etc. 

      

     Substitute(Substitute(Substitute(
     g_Letter_Text;
      
     "Full Address" ; Billing_Address 1 & ¶ & Billing_Address 2 & ¶ & Billing_Address 3 & ¶ & Billing_Address 4 & ¶ & Billing_Address 5 & ¶ & Billing_Country ) ;
     "For the Attention of: " ;FAO Text);
     "Contact"; Contact )
      
     The problem I have is that I dont know how to slide the address lines up, if for example there is no blling address 4. As I am not suing merge fields then the method should be added to this calculated field steps above. assume case/if but unsure how to add it and if it will work...
     Thanks

Outcomes