Search code examples
postgresqlregexp-replace

How can I remove square bracket using regexp in postgresql

my_Query -

SELECT (regexp_matches('datavalue=Document{{value=[5]}}', 'datavalue=Document{{value=([^d}},'']+)'))[1] response;

current output is square bracket - [5]

I require without square bracket - 5

enter image description here

Solution

  • To extract a part of a string based on a regex, substring() is the better alternative:

    substring('datavalue=Document{{value=[5]}}' from 'datavalue=Document{{value=\[([0-9]+)\]}}') response;