How do I delete all rows containing a certain text string? / rows containg x, y. or z

[pgalgiani]

Hi -- found a good script for this, but I need to delete rows that contain different variables and I don't know how to run that several times at one go - fr example delete all lines containing Fred,Paul, or Jim

This was the original script in the previous reply to another members question: --- it requires input fr the string, but I would prefer knowing how I could just embed the terms. Thanks in advance for help on this

Please Login or Register  to view this content.

Moderator's Note: When posting codes. Select the code then hit "#" sign to enclose the codes with code tags. Thank you and welcome to the forum.

[rylo]

Hi

Try this

Please Login or Register  to view this content.

rylo

[pgalgiani]

hey many thanks --- is there a tweak though so that for example "Paul" row would be deleted but it would not also delete "Paula" and "Apauling" -- but this gets me most of the way ----

[rylo]

Hi

If the words are surrounded by spaces, then include the spaces in the string. So for jim it would be

Please Login or Register  to view this content.

If it isn't likely to be contained within spaces, then what combinations would you be likely to expect? " jim" or "jim " perhaps?

rylo

[pgalgiani]

gets that's basic --- thanks ---

Just posted what I think will be my last part of the project I am working through

"assistance in changing data in one column based on another" if you got the time and inclination --- Phillip