Ever try removing a single " (quote symbol) from a string of text? HELP! Monarch Classic
Using Monarch Classic
I am working with a dataset that randomly includes records with a single " (quote symbol) in the string of text of a single field.
The problem I've had replacing or stripping the " from the text string is that you need the " " to define the character. Whenever I put the " inside the " " it prevents me from moving forward as it's expecting me to close the quote again with a fourth ".
Simple same text:
Bob"s Bike Store
This should be so simple but I keep hitting a wall. I just want to remove all " (quote symbols) from the string.
Thank you!