The function linked in another answer is insufficient. It fails to escape ^ or $ (start and end of string), or -, which in a character group is used for ranges. Use this function: function escapeRegex(string) { return string.replace(/[-\/\\^$*+?.()|[\]{}]/g, ‘\\$&’); } While it may seem unnecessary at first glance, escaping – (as well as ^) … Read more
You can use the following regex globally: \[(.*?)\] Explanation: \[ : [ is a meta char and needs to be escaped if you want to match it literally. (.*?) : match everything in a non-greedy way and capture it. \] : ] is a meta char and needs to be escaped if you want to … Read more
MySQL 8.0+: You can use the native REGEXP_REPLACE function. Older versions: You can use a user-defined function (UDF) like mysql-udf-regexp.
I’ve had a lot of experience running a compiled regex 1000s of times versus compiling on-the-fly, and have not noticed any perceivable difference. Obviously, this is anecdotal, and certainly not a great argument against compiling, but I’ve found the difference to be negligible. EDIT: After a quick glance at the actual Python 2.5 library code, … Read more
How you’d find a line break varies between operating system encodings. Windows would be \r\n, but Linux just uses \n and Apple uses \r. I found this in JavaScript line breaks: someText = someText.replace(/(\r\n|\n|\r)/gm, “”); That should remove all kinds of line breaks.
>>> import re >>> re.sub(‘ +’, ‘ ‘, ‘The quick brown fox’) ‘The quick brown fox’
The str.split() method without an argument splits on whitespace: >>> “many fancy word \nhello \thi”.split() [‘many’, ‘fancy’, ‘word’, ‘hello’, ‘hi’]
If you only want to extract only positive integers, try the following: >>> txt = “h3110 23 cat 444.4 rabbit 11 2 dog” >>> [int(s) for s in txt.split() if s.isdigit()] [23, 11, 2] I would argue that this is better than the regex example because you don’t need another module and it’s more readable … Read more
You can do it using -v (for –invert-match) option of grep as: grep -v “unwanted_word” file | grep XXXXXXXX grep -v “unwanted_word” file will filter the lines that have the unwanted_word and grep XXXXXXXX will list only lines with pattern XXXXXXXX. EDIT: From your comment it looks like you want to list all lines without … Read more
For example (?<=This is)(.*)(?=sentence) Regexr I used lookbehind (?<=) and look ahead (?=) so that “This is” and “sentence” is not included in the match, but this is up to your use case, you can also simply write This is(.*)sentence. The important thing here is that you activate the “dotall” mode of your regex engine, … Read more