By using this website, you agree to our Terms of Use (click here)
We currently have a setting in the import for Replace Staff Notes which is shown below for the “Amazon Order ID” to go into the Customer Reference on the SO.
This work however it also includes the “Amazon Earliest Ship Date” as well. How do I just get the “113-9876544-12345677” and nothing else? Here is the statement: =iif([OrderData.PaymentMethod]='amazon',Replace( [OrderData.StaffNotes], 'Amazon Order Id ',''),'')
Amazon Order Id 113-9876544-12345677
Amazon Earliest Ship Date 2021-11-22T08:00:00.000Z
Amazon Earliest Delivery Date 2021-11-24T08:00:00.000Z
Amazon Latest Ship Date 2021-11-24T07:59:59.000Z
Amazon Latest Delivery Date 2021-11-27T07:59:59.000Z
Amazon Fulfilment Method FBM
Hi,
Can you just use Substring to pick up "113-9876544-12345677" like this?
=IIf([OrderData.PaymentMethod]='amazon', Substring([OrderData.StaffNotes], 29, 20 ),'')