No, not every email will begin with 'Order Confirmation'. This is entered manually by the receiver. Isn't there logic in access to pull a specific range of characters after the # sign?
Yes that is exactly what's happening. I've inherited this project unfortunately. The idea is to join on the subject line which contains: Order Confirmation # 638917872-001 Partial Order/$23.74 RECEIVED
I have a separate table with all order numbers. I'd like to pull just the order number...
I have a similar issue and have yet to be able to figure out how to join these two tables. I have one table that has several pieces data in one column and I need to join only some of this data to another table I created with the relative data.
Little background: we receive confirmations of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.