...
Code Block |
---|
IF(NOT(ISBLANK(OtherCity)),OtherCity+" ","")+ IF(NOT(ISBLANK(OtherState)),OtherState+" ","")+ IF(NOT(ISBLANK(OtherCountry)),OtherCountry+" ", IF(NOT(ISBLANK(MailingCity)),MailingCity+" ","")+ IF(NOT(ISBLANK(MailingState)),MailingState+" ","")+ IF(NOT(ISBLANK(MailingCountry)),MailingCountry+" ", "")) LEFT( IF(NOT(ISBLANK(OtherCity)),OtherCity+" ","")+ IF(NOT(ISBLANK(OtherState)),OtherState+" ","")+ IF(LOWER(OtherCountry) = "Australiaaustralia","",IF(NOT(ISBLANK(OtherCountry)),OtherCountry+" ", IF(NOT(ISBLANK(MailingCity)),MailingCity+" ","")+ IF(NOT(ISBLANK(MailingState)),MailingState+" ","")+ IF(LOWER(MailingCountry) = "Australiaaustralia","",IF(NOT(ISBLANK(MailingCountry)),MailingCountry+" ", "")))) ,75) |
...