> 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
On Sat, Dec 10, 2022 at 6:32 AM Peter J. Holzer wrote:
> On 2022-12-10 11:00:48 +, Eagna wrote:
> > > 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 t
On 2022-12-10 11:00:48 +, Eagna wrote:
> > 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.
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 into an array is the most
> useful option.
OK - I *_ki
Hi, and thanks for your input,
> Tha said, the replacement string in some editors (like Vim) and some
> programming languages (like Perl) provides syntax for changing case
> (both vi(m) and Perl use \u and \U...\E for uppercasing).
This is probably why I was so frustrated - I thought that ther
On Saturday, December 10, 2022, Eagna 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
On 2022-12-10 09:40:22 +, Eagna wrote:
> I want a regex to change the case of a field from UPPER to lower.
First a note about terminology: A regular expression matches a string,
it doesn't replace anything.
The regexp_replace function uses a regular expression to match parts of
a string and t
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 thin
