Escape characters
Posted: Tue Feb 12, 2008 6:08 pm
Righty ho, nearly there!
I'm currently writing an application that takes some files and creates an SQL file that I can use to get the data into a database.
So far, all's going well and thanks to the guys here for the help - couldn't have done it without either RunRev or your help!
Anyway, at the final fence now and I'm outputting to a file, thing is, some of my text files have apostrophes and quotes in them, so when the sql file is written, it breaks when running it.
I'm using MySQL so it requires a backslash in front of any quotes in order to escape them and I was wondering if there's a way of doing this easily within RunRev.
I tried:
But that didn't work (didn't really expect it to).
Any ideas?
I'm currently writing an application that takes some files and creates an SQL file that I can use to get the data into a database.
So far, all's going well and thanks to the guys here for the help - couldn't have done it without either RunRev or your help!
Anyway, at the final fence now and I'm outputting to a file, thing is, some of my text files have apostrophes and quotes in them, so when the sql file is written, it breaks when running it.
I'm using MySQL so it requires a backslash in front of any quotes in order to escape them and I was wondering if there's a way of doing this easily within RunRev.
I tried:
Code: Select all
replace "'" with "''" in wRestAny ideas?