02-12-2007 10:43 AM
02-12-2007 11:05 PM - edited 02-12-2007 11:05 PM
@john_joe wrote:
I am reading a large txt file that contains sigle quotes and double quotes... I want to format the string and send it to a blob cell in mysql. I need to add an escaoe character before single quotes and double quotes. Any suggestions?
Yes! Use "Search and Replace String" with "replace all?" = True. Replace "'" with "\'" and replace """ with "\"".
Cheers.
Message Edited by tbd on 02-12-2007 11:06 PM