UnsolvedCoding
Technical User
I want to replace all ' in the string with nothing so that when I load it into SQL I don't keep running into problems. The code given works to replace only one ' and then stops looking.
I have been looking for awhile and can't find any code samples to say how to do this and I know it can be done.
My code -
sCOMMENT_TEXT = Replace(sCOMMENT_TEXT, "'", "")
How do I replace all ' in the string?
I have been looking for awhile and can't find any code samples to say how to do this and I know it can be done.
My code -
sCOMMENT_TEXT = Replace(sCOMMENT_TEXT, "'", "")
How do I replace all ' in the string?