Formula to clean data containing smart quotes and line breaks
Hi, I am working with text data that possibly contains smart quotes or curly quotes that I need to clean up. I want to remove any line breaks as well. What is the formula I can use? gsub?
Amanda Wong
said
about 2 years ago
Yes, you can use gsub to achieve that. Take a look at this recipe example here.
Saul Macht
Formula to clean data containing smart quotes and line breaks
Hi, I am working with text data that possibly contains smart quotes or curly quotes that I need to clean up. I want to remove any line breaks as well. What is the formula I can use? gsub?