I have used Regex with editors, Grep and Gnumeric (spreadsheet).
Regex syntax is not the same in all apps. Documentation is pretty sketchy on most apps concerning the use of Regex.
You never work on data that cannot be recovered.
It is amazing how fast Grep can strip patterns from text data. Huge file of text data in seconds or a few minutes.
I love command line apps for their efficiency. At one time I maintained about 80,000 images (& thumbnails). When the company I worked for then went to the web with their catalog I created all the images for the web from the print type images using Image Magick. I entered the command to create the images and simply went home for the evening. I do not know what time it finished the batch, but it was not even half the night.
As I added images I would batch process the new images and create the thumbnails using Image Magick. It would take only seconds to process several hundred images at a time. And the quality was great.