If you are a power user of Microsoft Excel most probably you wouldn’t say no to some nice add-on that would let you use regular expression to search and replace in your Excel workbooks. Regular Expression Find is able to search and replace in the whole workbook or just in a sheet. This nice Excel […]
Tag: Regex
If you happen to ignore the secrets of regular expressions and you need to perform these rather common tasks, here is how you can do it. A most useful search (and replace or remove) command is when you need to get rid of some links. /<a href=”http:\/\/domain\.com[^>]*>([\s\S]*?)<\/a>/ The formula above will find any domain.com link. […]
Search RegEx is a useful plugin, provided you are familiar with regular expressions. In the examples below I’m showing how you can replace all occurences of some shortcode or tag. Let’s say you have the shortcode [yourshortcode thevalue=”several values”]. Since “several values” can be whatever, you need a regular expression to include any possible value. […]
| — A vertical bar separates alternatives. For example, gray|grey can match “gray” or “grey”. ( ) — Parentheses are used to define the scope and precedence of the operators (among other uses). For example, gray|grey and gr(a|e)y are equivalent patterns which both describe the set of “gray” and “grey”. ? — The question mark […]
ScanFS is a free (for personal use) and powerful program that lets you search your files, even their content, to just locate them or perform replacements, even using regular expressions or via command line arguments! The program is able to create catalogues of local or removable drives, but you can use it only to search […]
WildGem is a free utility that provides a WYSIWYG interface for the use regular expressions, this way letting you perform powerful search and replace operations without even knowing how to write a regular expressions query! When you search with WildGem you have two panes and you are able to see the text and the results […]