it's occurred to me before that 'learning regex' is a solution that only emerges in my life whenever something has gone very wrong somewhere else

Regex is a godsend for badly formatted datasets.
All datasets are badly formatted for some applications.
The "very wrong" part of my life is working with data.