replace inside regexp_replace
От
Oliver Kohll
Тема
replace inside regexp_replace
Дата
Msg-id
CAMS=m5+sh7=4jtEGmgxyQ8OfiL=5YM8DUYQN5UxKZBdtotBsNQ@mail.gmail.com
Список
Дерево обсуждения
replace inside regexp_replace Oliver Kohll <oliver@agilechilli.com>
Re: replace inside regexp_replace hubert depesz lubaczewski <depesz@depesz.com>
Re: replace inside regexp_replace Francisco Olarte <folarte@peoplecall.com>
Re: replace inside regexp_replace Oliver Kohll <oliver@agilechilli.com>
Re: replace inside regexp_replace "David G. Johnston" <david.g.johnston@gmail.com>
Hi,
I have some text
'here is [[my text]] to replace and [[some more]]'
which I want to transform to
'here is my_text to replace and some_more'
i.e. wherever there are double square brackets, remove them and replace spaces in the contents with underscores.
My attempt to do that is the regex
select regexp_replace(
'here is [[my text]] to replace and [[some more]]',
E'\\[\\[(.*?)\\]\\]',
replace(E'\\1', ' ', '_'),
'g'
);
E'\\[\\[(.*?)\\]\\]',
replace(E'\\1', ' ', '_'),
'g'
);
which results in
'here is my text to replace and some more'
It half works, i.e. it removes the brackets but doesn't seem to process the inner replace. It's as if the select were just
select regexp_replace(
'here is [[my text]] to replace and [[some more]]',
E'\\[\\[(.*?)\\]\\]',
E'\\1',
'g'
);
E'\\[\\[(.*?)\\]\\]',
E'\\1',
'g'
);
I've a feeling I'm missing something fundamental, any idea what?
Thanks
Oliver
В списке pgsql-general по дате отправления
От: Brajendra Pratap Singh
Дата:
