Hi-
I have a text field and would like to replace quotes (") in the text with a space.
I've tried using translate(field,""","") and it doesn't work. Any suggestions would be greatly appreciated.
Thanks.
Please give this a try:
translate(field, '"', " ")
Note that this part '"', " " is apostrophe double-quote apostrophe comma double-quote space double-quote.