Good day all,
I need some assistance to process a string to be in an organised report to copy to an excel spreadsheet.
Here is an example of the string and I have attached the layout of the report:
**Start**SAECPFR Natal SCM Production MTN SIBONGILEN 24/06/19 13:39:44 Page 1 101122 FRESH ORDER LIST Facility Warehouse. . . .: 2 03 Delivery Date. . . . . . .: 26/06/19 Buyer Sequence - Detail Restrict To Vendor Number: Restrict To Store Number .: Restrict to Country . . .: Buyer ID : B04 BALAN CHETTY Vendor. .: 0102966 VEGEWORTH CC Vendor Order Number : ____________ Item. . .: 2394175 2394175 VEGEWORTH SALAD POTATO Size : 300G Pack : 8 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11592 HILLCREST KWIKSPAR FR:12/6/17 41064 2 2 __________ 076 ========= ========= Total for 2394175 2394175 VEGEWORTH SALAD POTATO : 2 2 BOH: On Ord Qty: 2 Item. . .: 2394291 2394291 V/WORTH SAL T/T POT&COLE Size : 300GR Pack : 8 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11592 HILLCREST KWIKSPAR FR:12/6/17 41064 1 1 __________ 076 ========= ========= Total for 2394291 2394291 V/WORTH SAL T/T POT&COLE : 1 1 BOH: On Ord Qty: 1 Item. . .: 2394993 2394993 VEGEWORTH SALAD COLESLAW 300G Size : 300G Pack : 8 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11592 HILLCREST KWIKSPAR FR:12/6/17 41064 2 2 __________ 076 ========= ========= Total for 2394993 2394993 VEGEWORTH SALAD COLESLAW 300G : 2 2 BOH: On Ord Qty: 2 Item. . .: 2455496 2455496 VEGWORTH SALAD BEETROOT Size : P/KG Pack : 2 Pick Slot : 000000 Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 10948 FOURWAYS KWIKSPAR / TOPS 41146 1 1 __________ 085 ========= ========= Total for 2455496 2455496 VEGWORTH SALAD BEETROOT : 1 1 BOH: On Ord Qty: 1 Item. . .: 2456158 2456158 VEGWORTH SALAD CHAKALAKA 2'S Size : 2.5KG Pack : 2 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11627 BLUFF S/S & TOPS FR:01.02.18 41066 1 1 __________ 094 ========= ========= Total for 2456158 2456158 VEGWORTH SALAD CHAKALAKA 2'S : 1 1 BOH: On Ord Qty: 1 Item. . .: 2456270 2456270 VEGEWORTH SALAD CREAMY POTATO Size : 2.5KG Pack : 2 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11627 BLUFF S/S & TOPS FR:01.02.18 41066 1 1 __________ 094 ========= ========= Total for 2456270 2456270 VEGEWORTH SALAD CREAMY POTATO : 1 1 BOH: 1 On Ord Qty: 1 Item. . .: 2456458 2456458 V/WORTH SALAD BABY POTATO Size : 2.5KG Pack : 2 Pick Slot : FL00A Store Store Delivery Name Ord No Orig O/Qty Accept Qty Actual Qty Loadpoint 11627 BLUFF S/S & TOPS FR:01.02.18 41066 1 1 __________ 094 ========= ========= Total for 2456458 2456458 V/WORTH SALAD BABY POTATO : 1 1 BOH: On Ord Qty: 1**End**
Bookmarks