Delete row if it equal to

wilder · Post by **wilder** » Thu Jul 02, 2009 10:56 pm

Hello everybody,

I have a problem with 5 textpad files that has more than 30 000 lines.

The first 4 digits of every lines are numbers like "01530, 02216, 02399" and so on.

Some number could be on 35 lines, others on 54 lines. Never the same.

Now, what I would like to do it to delete multiple lines at the same time.

If I have the same number that I listed above some where, I donâ€™t know yet, but let's say that in another textpad file, I have a list of multiple numbers.

By referencing to that list of number, it would delete all lines that have this numbers

It would leave only the ones that are not in the list.

I donâ€™t know if it's clear

ex:

First list on number:

01530
01622
02222

Second list:

01544 34 234
01546 57 1111
01622 33 99
02221 23 79
02222 12 2134

Now after the macro, for the second list, it would delete the row for 01622 and 02222.

The final result:
01544 34 234
01546 57 1111
02221 23 79

Do you think it's possible?

Thanks for your help.

JM

Bob Hansen · Post by **Bob Hansen** » Fri Jul 03, 2009 2:11 am

This sounds very similar to a question that I just answered in the past 2 weeks. Don't recall the subject, will need to find out what that was.....

ak47wong · Post by **ak47wong** » Fri Jul 03, 2009 4:38 am

Was it this one?

wilder · Post by **wilder** » Sat Jul 04, 2009 11:37 am

Thanks everybody.

Perfect. Now it work.

Bob Hansen · Post by **Bob Hansen** » Sat Jul 04, 2009 3:00 pm

Yes, ak47wong, that was it. Thanks for locating that, you were much faster than I was!