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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Expression Editor (Replace)
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Expression Editor (Replace)
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.
Untested, but I think it is right.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest