Re: Regular expression to UPPER() a lower case string

2022-12-11 Thread Peter J. Holzer
On 2022-12-10 15:48:58 +0100, Peter J. Holzer wrote: > On second thought you could probably use NFD normalization to separate > base letters from accents, uppercase the base letters and then > (optionally) NFC normalize everything again. Of course I had to try that: wds=> select normalize(

Re: Regular expression for lower case to upper case.

2022-12-11 Thread Alban Hertroys
> On 10 Dec 2022, at 12:00, Eagna wrote: > > > Hi, and thanks for your input. > > >> 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