I have the following case:
NEW FILE
blabla blabla blable ItemID=94374042 blabla blablublibla blable other_data
blabla blabla blable ItemID=91087082 blabla blabla blbleblaable other_data
blabla blabla blable ItemID=92415300 blabla blabla blablingble other_data
bplofla blabla blable ItemID=91584918 blabplbangofla blabla blable other_data
blabla blabla blable ItemID=95484087 blabla blapowbla blaplofble other_data
bhahalabla blabla blable ItemID=93881915 blabla blabla blable other_data
blablabli blabla blable ItemID=93391409 blabla blabla blable other_data
blabla blblublzabla blable ItemID=94508261 blabla blabandla blable other_data
OLD FILE 1
blabplofla blabla blable ItemID=95709167 splashlabla blabla blable other_data
blabla blabla blable ItemID=94889375 blabla blabbingla blable other_data
blabla blabla blable ItemID=91087082 blabla blabla blable other_data
bpifflabla blabla blable ItemID=93989584 blabla blabla blable other_data
blabla blabla blable ItemID=91930654 blabla blabla bangblable other_data
blabla blabla blable ItemID=93621288 blabla blabla blasockble other_data
blabla blabla blable ItemID=96507582 blabla blabla blable other_data
blablabli blabla blable ItemID=92221673 blabla blabla blable other_data
blabla blablabluble blable ItemID=93391409 blabla blabla blable other_data
blabla bllololoaei blable ItemID=93775797 blabla blabla blable other_data
OLD FILE 2
blabplofla blabla blable ItemID=91424876 blabplofla blabla blable other_data
blabplofla blabla blable ItemID=93272698 blabplofla bingblabla blable other_data
blabfla blabla blable ItemID=94407207 blabplofla blabla blable other_data
bplofla blabla blable ItemID=91584918 blabplbangofla blabla blable other_data
blabbliplo blabla blable ItemID=95498779 blabplofla blabla blable other_data
blabploblu blabla blable ItemID=91634932 blabplofboffla blabla blable other_data
blabplofla blabla blable ItemID=90366946 blabplofla blabla blwowable other_data
bleepbplofla blabla blable ItemID=92169269 blabplofla blabla blable other_data
I need to remove the lines from the NEW file that contain an "ItemID" already present in one or other of the OLD files.
The rest of the content of the line is of no importance.
OLD files are only a few at the moment, all in the same folder and guaranteed not to hold dupes, about 1500 lines in all.
At the end they should grow in size and number to a total of about 30'000 lines or more. I don't mind waiting a few seconds for the dupe-check to complete.
Question: what happens to the execution of the macro if the NEW file is constituted solely of duplicate ItemId's? At the end of my work this might occur.
I have not been able to get either ReplInFiles or FindInFiles give what I need, but it's probably due to my non-knowledge (commonly called ignorance ).
Thank you for your help!!
DoduEd
NEW FILE
blabla blabla blable ItemID=94374042 blabla blablublibla blable other_data
blabla blabla blable ItemID=91087082 blabla blabla blbleblaable other_data
blabla blabla blable ItemID=92415300 blabla blabla blablingble other_data
bplofla blabla blable ItemID=91584918 blabplbangofla blabla blable other_data
blabla blabla blable ItemID=95484087 blabla blapowbla blaplofble other_data
bhahalabla blabla blable ItemID=93881915 blabla blabla blable other_data
blablabli blabla blable ItemID=93391409 blabla blabla blable other_data
blabla blblublzabla blable ItemID=94508261 blabla blabandla blable other_data
OLD FILE 1
blabplofla blabla blable ItemID=95709167 splashlabla blabla blable other_data
blabla blabla blable ItemID=94889375 blabla blabbingla blable other_data
blabla blabla blable ItemID=91087082 blabla blabla blable other_data
bpifflabla blabla blable ItemID=93989584 blabla blabla blable other_data
blabla blabla blable ItemID=91930654 blabla blabla bangblable other_data
blabla blabla blable ItemID=93621288 blabla blabla blasockble other_data
blabla blabla blable ItemID=96507582 blabla blabla blable other_data
blablabli blabla blable ItemID=92221673 blabla blabla blable other_data
blabla blablabluble blable ItemID=93391409 blabla blabla blable other_data
blabla bllololoaei blable ItemID=93775797 blabla blabla blable other_data
OLD FILE 2
blabplofla blabla blable ItemID=91424876 blabplofla blabla blable other_data
blabplofla blabla blable ItemID=93272698 blabplofla bingblabla blable other_data
blabfla blabla blable ItemID=94407207 blabplofla blabla blable other_data
bplofla blabla blable ItemID=91584918 blabplbangofla blabla blable other_data
blabbliplo blabla blable ItemID=95498779 blabplofla blabla blable other_data
blabploblu blabla blable ItemID=91634932 blabplofboffla blabla blable other_data
blabplofla blabla blable ItemID=90366946 blabplofla blabla blwowable other_data
bleepbplofla blabla blable ItemID=92169269 blabplofla blabla blable other_data
I need to remove the lines from the NEW file that contain an "ItemID" already present in one or other of the OLD files.
The rest of the content of the line is of no importance.
OLD files are only a few at the moment, all in the same folder and guaranteed not to hold dupes, about 1500 lines in all.
At the end they should grow in size and number to a total of about 30'000 lines or more. I don't mind waiting a few seconds for the dupe-check to complete.
Question: what happens to the execution of the macro if the NEW file is constituted solely of duplicate ItemId's? At the end of my work this might occur.
I have not been able to get either ReplInFiles or FindInFiles give what I need, but it's probably due to my non-knowledge (commonly called ignorance ).
Thank you for your help!!
DoduEd