I have a file which contains customer data...
200000000000000475559xxxxxxxxxxxxCARDCX10 GBMRS. xxx xxxxxx xxxx xxxxxxx & CO LTD xxx xxxxxx ROAD ^I COLCHESTER ESSEX^I xxx xxx xxxx.xxxxx@GOOGLEMAIL.COM 0000000000000912906R0000000000000000000000000000 07509207499
I need to be able to strip out everything from the file so I am only left with the order number (0000000000000912906R)
The lenght of the columns can vary depending on the name, address etc but it appears that the order number is the second from last column.
Any help would be greatly appreciated.