Hello Greetings!
I need some assistance in below code. I am trying to replace all the double quotes with single quotes for a text in a .sql file. I tried using StringReplace & RegReplace but no luck.
#include <Date.au3>
$sip = @IPAddress1
$user = "test-admin"
$FileHandle = FileOpen(@ScriptDir &"\commands.sql", 2)
FileWrite($FileHandle,"insert into serverAccess values ("""&@UserName&""","""&$sip&""","""&$user&""","""& _Now()&""")")
StringReplace(FileRead($FileHandle), """", "'")
Your assistance will be very helpful. Thanks