On Saturday, December 10, 2022, Eagna <ea...@protonmail.com> wrote: > > > Hi all, > > > I want a regex to change the case of a field from UPPER to lower. > > I know about the UPPER() and LOWER() functions and they are not what I > want. > > I would have thought this should be very simple, but I've searched a lot > and can't seem to get an answer. > > Here's a fiddle with a couple of things that I've tried - I'm obviously > missing something that should be starting me in the face. > > Any input appreciated. > > > E. > > > RegExp by itself cannot do this. You have to match all parts of the input into different capturing groups, then use lower() combined with format() to build a new string. Putting the capturing groups into an array is the most useful option.
David J.