Remove common unwanted words

[#1]

Hi All

I'm trying to clean data for matching purposes and I need to remove certain common words from some fields.

For example, in a NAME field I might have "Socitey For The Blind" and the words "for" and "the" are on my list of common words, so I want to return only "Society Blind" for matching purposes.

MapSubString doesn't work because it's not iterative and the best I can get back is "Socitey The Blind".

There must be a smart way to do this?

[#2]

Hi Brian,

sometimes a combination of string functions are able do the job.

See QV help and look for "PurgeChar" as example.

Hope it helps.

Good luck!

Rainer