Weed out words?

  tnelis 10:47 05 Apr 2004

Is there a way to automatically isolate an appearance of a word in a list of words, eg I have a full dictionery of words, and I want to end up with a list where the word "log" appears. So if the big list contains:


The resulting list would be:



  AbodeMilano 11:01 05 Apr 2004

Is this in relation to a program, or one you are writing?

  tnelis 11:07 05 Apr 2004

All I have is a big text file of words, each on a seperate line....I need this because I am inventing a word puzzle which involves finding all words that contain another specific word eg "log" is found in "catalogue" and many other words.

  AbodeMilano 11:10 05 Apr 2004

What program are you using to view the text file?

  tnelis 11:13 05 Apr 2004

You know the tool "find and replace" in Word? Well I need something like "find and isolate" so I am left with only the relevant words??

  118-118 Got Your Number 11:21 05 Apr 2004

Have you got Excel?

  tnelis 12:33 05 Apr 2004

yes, i got excel...Can I use that for this problem?

  118-118 Got Your Number 15:56 05 Apr 2004

It is a lot easier to filter text in Excel than in Word.

If you look up the Text Based Functions such as =Find =Left =Right etc.

Open your text file in excel - a text import wizard will come up and once you have completed it, you will be able to apply conditions to various cells to look for your 'log' text string.

=Find() looks as though it will do the job for you as follows:-

=find("log",[enter cell ref here],1)

Using this formula will return a numeric value upon finding "log". eg catalogue will = 5 because the letter 'L' is the fifth character from the left of the beginning of the text string.

If 'log' doesn't exist then the standard #value error will appear. From here you can just ignore/delete them as you see fit.

  tnelis 16:18 05 Apr 2004

Great....good solution, thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?