Look at that other FAQ with a similar, although more general topic: How to strip several different characters from a string? Mark's first sample should do the trick. answered 11 Feb '16, 09:09 Volker Barth |
Regular Expressions are useful in search criteria but not really applicable to string manipulation. You can try using the REPLACE() function, as in:
And yes, there are 3 nested calls to this function, 1 per character to be replaced. answered 11 Feb '16, 12:17 Nick Elson S... |