replace() funciton with multiple tests....
so basically I'm looking to do the following, which obv doesn't work...
Replace(string, Or("purge_", "dealdrop_"), "cor010_wcout")
I've tried Replace(string, Array("purge_", "dealdrop_"), "cor010_wcout") which also doesn't work.
since i'll never be in a situation where string will contain both purge_ and dealdrop_ I've gone the route of running the replace function twice as follows:
tempstring = Replace(string, "purge_", "cor010_wcout")
tempstring = Replace(string, "dealdrop_", "cor010_wcout")
but there's Got to be a more elegant way than just trying to shove a square peg in a round hole with a big hammer... ideas?
|