[GENERAL] String substitution with "translate" function

2000-11-15 Thread Jeff Eckermann
(My first attempt at posting didn't make it to my mailbox, so I am reposting. Apologies to any who get this twice.) I have been trying to use the translate function to delete a specific string from entries in a particular column, as in "translate(, 'string', '')". What I find is that "translate"

[GENERAL] String substitution with "translate" function

2000-11-15 Thread Jeff Eckermann
I have been trying to use the translate function to delete a specific string from entries in a particular column, as in "translate(, 'string', '')". What I find is that "translate" is treating the nominated string as a character class, and is deleting every instance of every character in that clas