Power Query vs regex
With thanks to thebiaccountant for the idea!!!
I wanted a function to test if a user-entered field which was supposed to have hex codes had valid data. Easy enough to do? regex has it down... not so much in PQ...
To this end, I created a pair of PQ functions - one a "generic" regex.test function, and another which calls the first one specifically for testing HexCodes