Perl Search/Replace between 2 huge files

[ocon]

Hello all,

I have a perl question. I need to remove the lines from 1 file that have a string matching a line on a different file, I could write a script with sed or grep, but one file is 200 mb and the other one is 6 mb... just imagine.

Here is the example:

200mbfile:
key1X,fild2,fild3,fild4,fild5
key1C,fild2,fild3,fild4,fild5
key1V,fild2,fild3,fild4,fild5
key1B,fild2,fild3,fild4,fild5
key1N,fild2,fild3,fild4,fild5

6mbfile:
keyC
keyB

Having this said... I need to create a new file with data from 200mbfile that is not key'd on the 6mb file... example:
key1X,fild2,fild3,fild4,fild5
key1V,fild2,fild3,fild4,fild5
key1N,fild2,fild3,fild4,fild5

Any Ideas? I was trying to do a foreach loop, but I was sugested to use hashes instead, but still, cant figure out how to do this effectively, any help is appreciated!

Regards,
OCON

[drl]

Hi.

...
200mbfile:
key1X,fild2,fild3,fild4,fild5
key1C,fild2,fild3,fild4,fild5
key1V,fild2,fild3,fild4,fild5
key1B,fild2,fild3,fild4,fild5
key1N,fild2,fild3,fild4,fild5

6mbfile:
keyC
keyB

Having this said... I need to create a new file with data from 200mbfile that is not key'd on the 6mb file... example:
key1X,fild2,fild3,fild4,fild5
key1V,fild2,fild3,fild4,fild5
key1N,fild2,fild3,fild4,fild5

...

How is the matching supposed to be done? You have apparently done something with, say keyC, so that the line

key1C,fild2,fild3,fild4,fild5

is filtered out. However, there is an additional character, "1" between "key" and "C" ... cheers, drl

[ocon]

Hello!

I was wondering why I didn't got any reply before... it was a typo... well things were more complicated but I am just about to figure it out, just having some issues with a regexp, but I am almost done.

Thank you for pointing that out; and of course, for replying!
Ocon

[scathefire]

regular expression you say? this tool has saved me so much time. i recommend it for all.

RegExr: Online Regular Expression Testing Tool