murray83
Games Collector
- Local time
- Today, 15:44
- Joined
- Mar 31, 2017
- Messages
- 844
ok another similar question
how would i chop the pdf when pasted into raw data so it got the address
Sales Order
From:
DHL SUPPLY CHAIN
DANES WAY
NORTHAMPTONSHIRE
CRICK NN6 7EX
UNITED KINGDOM
Ship To:
BEST FOOD LOGISTICS (PRET A MANGER)
RATTY'S LANE
HODDESDON EN11 0RF
UNITED KINGDOM
Order Number:
Customer Number:
Customer Ship To:
Customer Order No:
Due Date:
Booking Time:
Booking Ref:
ON00384524
C000794
1
349792
12/06/2025
22.00 -
408913
Line Customer SKU HS Product Code Line Weight Qty UM Pallets
1 PMA984213 120750015PSSC PRET 75CL STILL SPORTS 20,857.20 2,184 CA 26.00
customer.logistics@highlandspringgroup.com;evcs.highlandspring@evcargo.com;gaylord.mutambiranwa2@dhl.com;gordon.eyles@dhl.com;jayce.baldwin@DHL.com;M.Carpenter@dhl.com;mark.simmonds@dhl.com;mark.trueman@dhl.com;michael.dunham@dhl.com;philibert.nsaata@dhl.com;TrafficControl@Highlandspringgroup.com
Please pick the attached order ready for collection. Contact customer.logistics@highlandspringgroup.com with any issues.
all weights specified in kilograms
Total Qty:
Total Qty Weight:
Total Pallets:
Total Pallet Weight:
Total Overall Weight:
2,184.00
20,857.20
26.00
728.00
21,585.20
If this order is delivered incorrectly please contact Highland Spring Group Customer Support on 01764 660 525
HAULIER INFORMATION / RECEIVED IN GOOD CONDITION
Driver's Signature:
Reg Number:
Trailer Number:
Date Collected:
No. of Straps:
No. of Straps Used:
RECEIVED IN GOOD CONDITION
Signed:
Date:
Time:
As i thought about SQL but then that wouldnt work as not all address details are fixed length, so would need to chop out the post code at the least and then i could use that as a join as i have all address used in anotehr table
how would i chop the pdf when pasted into raw data so it got the address
Sales Order
From:
DHL SUPPLY CHAIN
DANES WAY
NORTHAMPTONSHIRE
CRICK NN6 7EX
UNITED KINGDOM
Ship To:
BEST FOOD LOGISTICS (PRET A MANGER)
RATTY'S LANE
HODDESDON EN11 0RF
UNITED KINGDOM
Order Number:
Customer Number:
Customer Ship To:
Customer Order No:
Due Date:
Booking Time:
Booking Ref:
ON00384524
C000794
1
349792
12/06/2025
22.00 -
408913
Line Customer SKU HS Product Code Line Weight Qty UM Pallets
1 PMA984213 120750015PSSC PRET 75CL STILL SPORTS 20,857.20 2,184 CA 26.00
customer.logistics@highlandspringgroup.com;evcs.highlandspring@evcargo.com;gaylord.mutambiranwa2@dhl.com;gordon.eyles@dhl.com;jayce.baldwin@DHL.com;M.Carpenter@dhl.com;mark.simmonds@dhl.com;mark.trueman@dhl.com;michael.dunham@dhl.com;philibert.nsaata@dhl.com;TrafficControl@Highlandspringgroup.com
Please pick the attached order ready for collection. Contact customer.logistics@highlandspringgroup.com with any issues.
all weights specified in kilograms
Total Qty:
Total Qty Weight:
Total Pallets:
Total Pallet Weight:
Total Overall Weight:
2,184.00
20,857.20
26.00
728.00
21,585.20
If this order is delivered incorrectly please contact Highland Spring Group Customer Support on 01764 660 525
HAULIER INFORMATION / RECEIVED IN GOOD CONDITION
Driver's Signature:
Reg Number:
Trailer Number:
Date Collected:
No. of Straps:
No. of Straps Used:
RECEIVED IN GOOD CONDITION
Signed:
Date:
Time:
As i thought about SQL but then that wouldnt work as not all address details are fixed length, so would need to chop out the post code at the least and then i could use that as a join as i have all address used in anotehr table