How do I update a field in Sage with a blank value from the data source? (1 reply)
Resolved. Malformed XML.
Resolved. Malformed XML.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
I have a XML file with three address fields. If my ARCUS record contains:
123 Main Street
Top Floor
(blank)
and my XML file now contains:
567 Second Street
I'm having a hard time getting the second address line in Sage to be blank. Right now, in ARCUS, I end up with:
567 Second Street
Top Floor
(blank)
I've tried forcing a blank space on to the end of the field in a Map transform:
trim(%address2) & " "
but that doesn't seem to work.
Any ideas?