Replace Function with % (1 reply)
Try replace the string with % with the Chr function, where 37 is the % character (look this up using the Ascii table).
Replace(%Invoice, Chr(37), "#")
Try replace the string with % with the Chr function, where 37 is the % character (look this up using the Ascii table).
Replace(%Invoice, Chr(37), "#")
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 need to replace a % with # in a field, but as % is the Iman field identifier, I keep getting an error.
Replace(%Invoice,"%","#")
Is there anyway to tell Iman this is the character I want to replace. Have tried various brackets, but still doesn’t like it.