REPLACE function Question

Hi All,

Has anyone ever written a script to search a text string and change all the occurances of a list of values to their cooresponding mask value. I know that the RELACE function can do this for one string value. We have a table of mask values. It lists what the original value is and then what the mask should be. We need to search a text table and convert any values found in this table by using our look-up mask table. Have any ideas?

Thanks,
  Nancy Received on Mon Dec 18 2000 - 09:16:24 CST