SWI, text file looks like this
12LDF { ON HAND= 1,947 } { QTY ALOC= 864 } { QTY AVAIL= 1,083 } { WH1 AVG= 2,573 }
12LDF { ON HAND= 992 } { QTY ALOC= 0 } { QTY AVAIL= 992 } { WH2 AVG= 402 }
12LDF { ON HAND= 1,599 } { QTY ALOC= 32 } { QTY AVAIL= 1,567 } { WH3 AVG= 839 }
12LDF ----> SHOP1 MNTHS SUPPLY AVAILABLE= 1 SUGGESTED TO ORDER= 1699
12LDF TOTAL TO ORDER: 1699 'NEED TO DELETE THIS LINE
12LDF ----> SHOP2 MNTHS SUPPLY AVAILABLE= 0 SUGGESTED TO ORDER= 11209
12LDF TOTAL TO ORDER: 12908
13LDF { ON HAND= 3,648 } { QTY ALOC= 640 } { QTY AVAIL= 3,008 } { WH1 AVG= 597 }
13LDF { ON HAND= 1,296 } { QTY ALOC= 0 } { QTY AVAIL= 1,296 } { WH2 AVG= 294 }
13LDF { ON HAND= 2,018 } { QTY ALOC= 40 } { QTY AVAIL= 1,978 } { WH3 AVG= 305 }
13LDF ----> SHOP1 MNTHS SUPPLY AVAILABLE= 7 SUGGESTED TO ORDER= 0
13LDF TOTAL TO ORDER: 0 'NEED TO DELETE THIS LINE
13LDF ----> SHOP2 MNTHS SUPPLY AVAILABLE= 5 SUGGESTED TO ORDER= 0
13LDF TOTAL TO ORDER: 0
WITH THE CODE I CURRENTLY HAVE I GET THE FOLLOWING RESULTS:
12LDF { ON HAND= 1,947 } { QTY ALOC= 864 } { QTY AVAIL= 1,083 } { WH1 AVG= 2,573 }
12LDF { ON HAND= 992 } { QTY ALOC= 0 } { QTY AVAIL= 992 } { WH2 AVG= 402 }
12LDF { ON HAND= 1,599 } { QTY ALOC= 32 } { QTY AVAIL= 1,567 } { WH3 AVG= 839 }
12LDF ----> SHOP1 MNTHS SUPPLY AVAILABLE= 1 SUGGESTED TO ORDER= 1699
12LDF TOTAL TO ORDER: 1699 'NEED TO DELETE THIS LINE
12LDF ----> SHOP2 MNTHS SUPPLY AVAILABLE= 0 SUGGESTED TO ORDER= 11209
13LDF { ON HAND= 3,648 } { QTY ALOC= 640 } { QTY AVAIL= 3,008 } { WH1 AVG= 597 }
13LDF { ON HAND= 1,296 } { QTY ALOC= 0 } { QTY AVAIL= 1,296 } { WH2 AVG= 294 }
13LDF { ON HAND= 2,018 } { QTY ALOC= 40 } { QTY AVAIL= 1,978 } { WH3 AVG= 305 }
13LDF ----> SHOP1 MNTHS SUPPLY AVAILABLE= 7 SUGGESTED TO ORDER= 0
13LDF TOTAL TO ORDER: 0 'NEED TO DELETE THIS LINE
13LDF ----> SHOP2 MNTHS SUPPLY AVAILABLE= 5 SUGGESTED TO ORDER= 0
I JUST NEED TO KEEP THE 2nd DUPLICATE AND THE DELETE THE 1st ONE. THANK YOU