Source Field | Dest. Field |
##"Address"+IF(EQUALS("Address 2",''),'',PREPEND("Address 2",'<13,10>',LENGTH("Address 2")+2)) | BillingStreet |
Source Field | Dest. Field |
##IF(EQUALS(BEFORE(BillingStreet,'<10>'),''),BillingStreet,POSTDEL(BEFORE(BillingStreet,'<10>'),'<13>')) | Address |
##IF(EQUALS(BEFORE(BillingStreet,'<10>'),''),'',AFTER(BillingStreet,'<10>')) | Address 2 |