Have you tried: eval $cmd For the follow-on question of how to escape * since it has special meaning when it’s naked or in double quoted strings: use single quotes. MYSQL=’mysql AMORE -u username -ppassword -h localhost -e’ QUERY=”SELECT “‘*'” FROM amoreconfig” ;# <– “double”‘single'”double” eval $MYSQL “‘$QUERY'” Bonus: It also reads nice: eval mysql … Read more
Try using the –% operator to put PowerShell into simple (dumb) argument parsing mode: curl.exe –% -ku user@email:mypass -X PUT -d “data={\”password\”:\”keypass\”}” https://build.phonegap.com/api/v1/key This is quite often useful for invoking exes with argument syntax that runs afoul of PowerShell’s argument syntax. This does require PowerShell V3 or higher.
The String#replaceAll() interprets the argument as a regular expression. The \ is an escape character in both String and regex. You need to double-escape it for regex: string.replaceAll(“\\\\”, “\\\\\\\\”); But you don’t necessarily need regex for this, simply because you want an exact character-by-character replacement and you don’t need patterns here. So String#replace() should suffice: … Read more
Actually, you can match all instances of a regex not inside quotes for any string, where each opening quote is closed again. Say, as in you example above, you want to match \+. The key observation here is, that a word is outside quotes if there are an even number of quotes following it. This … Read more
There are two easy and safe rules which work not only in sh but also bash. 1. Put the whole string in single quotes This works for all chars except single quote itself. To escape the single quote, close the quoting before it, insert the single quote, and re-open the quoting. ‘I’\”m a s@fe $tring … Read more
preg_quote() is what you are looking for: Description string preg_quote ( string $str [, string $delimiter = NULL ] ) preg_quote() takes str and puts a backslash in front of every character that is part of the regular expression syntax. This is useful if you have a run-time string that you need to match in … Read more
>>> print ‘”Hello,\\nworld!”‘.decode(‘string_escape’) “Hello, world!”
@@ should do it.
Most answers given here have a huge disadvantage: if the string you are trying to convert isn’t trusted then you will end up with a Cross-Site Scripting (XSS) vulnerability. For the function in the accepted answer, consider the following: htmlDecode(“<img src=”https://stackoverflow.com/questions/3700326/dummy” onerror=”alert(/xss/)”>”); The string here contains an unescaped HTML tag, so instead of decoding anything … Read more
The MySQL documentation you cite actually says a little bit more than you mention. It also says, A “’” inside a string quoted with “’” may be written as “””. (Also, you linked to the MySQL 5.0 version of Table 8.1. Special Character Escape Sequences, and the current version is 5.6 — but the current … Read more