Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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)

...