LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

format large string for mysql

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?
0 Kudos
Message 1 of 2
(2,549 Views)


@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

"Inside every large program is a small program struggling to get out." (attributed to Tony Hoare)
0 Kudos
Message 2 of 2
(2,542 Views)