postgresql : regexp_substr - get sub string between occurrence of delimiters

Question

I have these strings:

[{"Name":"id","Value":"Window_Ex_kebklipecbcegiocpa_widget_open"
[{"Name":"id","Value":"Window_Ex_kebklipecbcegiocpa_widget_close"
[{"Name":"id","Value":"Window_Ex_kebklipecbcegiocpa_widget_mid_value"

and I'm trying to extract only the parts after the third _, until the end of the string (which ends always with ")

widget_open
widget_close
widget_mid_value

I'm using postgresql, and wanted to use the regexp_substr syntax, in order to extract it. Thanks!

Show us what you tried and why that didn't work.

Gary_W
– Gary_W

2021-01-04 16:26:33 +00:00
Commented Jan 4, 2021 at 16:26 — Gary_W
– Gary_W, Commented Jan 4, 2021 at 16:26

Emilio Platzer · Accepted Answer · 2021-01-05 12:05:45Z

1

`regexp_replace(data::text,'^([^_]+_){3}','')`

You can try

select regexp_replace(data::text,'^([^_]+_){3}','')
  from (
      select 'one_two_three_four  s'::text as data 
      union select 'a_bb_ccc_dddd_eeee_ffff'
  ) data

edited Jan 5, 2021 at 12:05

answered Jan 5, 2021 at 0:00

Emilio Platzer

2,5191 gold badge23 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql : regexp_substr - get sub string between occurrence of delimiters

1 Answer 1

`regexp_replace(data::text,'^([^_]+_){3}','')`

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

regexp_replace(data::text,'^([^_]+_){3}','')

Comments

Your Answer

Sign up or log in

Post as a guest

Related

`regexp_replace(data::text,'^([^_]+_){3}','')`