🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Ever try removing a single " (quote symbol) from a string of text? HELP! Monarch Classic

User: "Amanda Hamm"
Altair Community Member
Updated by Amanda Hamm

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!

 

 

Find more posts tagged with