In a Transfer going from MS Dynamics NAV to Salesforce.com, use the following in the Field List:
| 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 |