Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Expression Editor (Replace)

Report design issues and solutions.
Post Reply
christina
User
User
Posts: 9
Joined: 16 Feb 2018, 22:08
Sage Version: v2018 24 UK/Europe/Africa

Expression Editor (Replace)

Post by christina » 04 Jan 2019, 23:26

Hi All

Wondering if someone can help, I am trying to use the replace function in the expression editor. I have all the replace data correct but I'm not 100% sure how to format the expression.

Currently, the expression is

SALES_ORDER.NOTES_3 = "" ? SALES_LEDGER.COUNTRY_CODE : SALES_ORDER.NOTES_3

but I need to add in the replace expression to change country codes that pull through to Notes 3 from our E-commerce channel so I need it to read something like the below but I can't seem to get it working (I feel I'm missing something after the SALES_LEDGER.COUNTRY_CODE: SALES_ORDER.NOTES_3 before the replace starts.

SALES_ORDER.NOTES_3 = "" ? SALES_LEDGER.COUNTRY_CODE : SALES_ORDER.NOTES_3

(replace(replace(replace(replace(SALES_ORDER.NOTES_3 "Belgium","BEL"),("Denmark","CNK"),("Finland","FIN"),("France","FRA"),

Any help would be fantastic.

Thank you

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4123
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Expression Editor (Replace)

Post by brucedenney » 05 Jan 2019, 20:12

SALES_ORDER.NOTES_3 = "Belgium"?"BEL":SALES_ORDER.NOTES_3 = "Denmark"?"CNK":SALES_ORDER.NOTES_3 = "Finland"?"FIN":SALES_ORDER.NOTES_3 = "France"?"FRA":SALES_ORDER.NOTES_3

Untested, but I think it is right.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest