getting separate words from memo and text field

  • Thread starter Thread starter Mr. T.
  • Start date Start date
M

Mr. T.

Hi,

i have a few tables with titles that are text-fields and descriptions that
are memo-fields. I would like to get the separate words from those tables to
put them in another table as a sort of index of what is in the db to make
searching in the database on a word easier.

Now my problem is to get the separate words out of the text- and
memo-fields. Because, certainly in the memo-fields, the "separator" isn't
always a space. Look to the text of this message for example. There's
sometimes a comma, sometimes a dot, etc...

If it were just separated with spaces it wouldn't be that much of a problem,
but with the possibility of different separators it's not that easy.

Anyone got any ideas or suggestions on how i could tackle this?

Regards,

Thomas L.
 
i would copy memo contents to a variable, then replace comma, dot, etc with
space, then get word from it, assuming separator is space
 
Back
Top