Usually a back-reference is either $1 or \1 (backslash one) for the first capture group (the first match of a pattern in parentheses), and indeed Sublime supports both syntaxes. So try: my name used to be \1 or my name used to be $1 Also note that your original capture pattern: my name is (\w)+ … Read more
I’m using Visual Studio Code 1.8, and this feature is available. But it’s a little tricky to understand at first, and (at the time of writing) the docs don’t explain clearly how to use it, so here’s how it works, step by step: Invoke Replace in Files (under the Edit menu, or with shortcut Ctrl+Shift+H) … Read more
var mystring = “crt/r2002_2″; mystring = mystring.replace(‘/r’,”https://stackoverflow.com/”); will replace /r with / using String.prototype.replace. Alternatively you could use regex with a global flag (as suggested by Erik Reppen & Sagar Gala, below) to replace all occurrences with mystring = mystring.replace(/\/r/g, “https://stackoverflow.com/”); EDIT: Since everyone’s having so much fun here and user1293504 doesn’t seem to be … Read more
str.replace() v2|v3 does not recognize regular expressions. To perform a substitution using a regular expression, use re.sub() v2|v3. For example: import re line = re.sub( r”(?i)^.*interfaceOpDataFile.*$”, “interfaceOpDataFile %s” % fileIn, line ) In a loop, it would be better to compile the regular expression first: import re regex = re.compile(r”^.*interfaceOpDataFile.*$”, re.IGNORECASE) for line in some_file: … Read more
To delete something without saving it in a register, you can use the “black hole register”: “_d Of course you could also use any of the other registers that don’t hold anything you are interested in.
You don’t need wildcards in the REPLACE – it just finds the string you enter for the second argument, so the following should work: UPDATE dbo.xxx SET Value = REPLACE(Value, ‘123’, ”) WHERE ID <=4 If the column to replace is type text or ntext you need to cast it to nvarchar UPDATE dbo.xxx SET … Read more
UPDATE your_table SET your_field = REPLACE(your_field, ‘articles/updates/’, ‘articles/news/’) WHERE your_field LIKE ‘%articles/updates/%’ Now rows that were like http://www.example.com/articles/updates/43 will be http://www.example.com/articles/news/43 How to find and replace text in a MySQL database
Strings in Python are immutable (can’t be changed). Because of this, the effect of line.replace(…) is just to create a new string, rather than changing the old one. You need to rebind (assign) it to line in order to have that variable take the new value, with those characters removed. Also, the way you are … Read more
$ prefix=”hell” $ suffix=”ld” $ string=”hello-world” $ foo=${string#”$prefix”} $ foo=${foo%”$suffix”} $ echo “${foo}” o-wor This is documented in the Shell Parameter Expansion section of the manual: ${parameter#word} ${parameter##word} The word is expanded to produce a pattern and matched according to the rules described below (see Pattern Matching). If the pattern matches the beginning of the … Read more
The easiest way is to use sed (or perl): sed -i -e ‘s/abc/XYZ/g’ /tmp/file.txt Which will invoke sed to do an in-place edit due to the -i option. This can be called from bash. If you really really want to use just bash, then the following can work: while IFS=” read -r a; do echo … Read more