You have chosen to sponsor your bid up to a maximum amount of .
We get emails sent to us every day when orders are shipped. We need a way to extract the tracking number and the order number so it dups it in an csv file and our system imports it. This needs to run every hour and the file need to be over written every hour so we don't get dup tracking infomation.
This is an example of how we get this info
Your Ref: 104386
Order No.: 1720208-0
Order Date: 04/09/2013
Carrier: ExpressPak NextDay
Taken By: WEB
Cover: PLAIN COVER
This script needs to export Order No.: 1720208-0 which is the tracking number but the -0 need to be remove and the order number which needs to be in a another column is Your Ref: 104386
Look forward to your comments