Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table "Table"("column" text);
insert into "Table" values 
  ('GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT')
  returning *;

CREATE TABLE

column

GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT

INSERT 0 1

--https://stackoverflow.com/q/77915210/5298879
SELECT "column" from "Table" LIMIT 1;

column

GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT

SELECT 1

select regexp_substr("column",'([^-]*-){3}(.*)(-[^-]*){2}', 1, 1, 'i', 2) 
from "Table"
limit 1;

regexp_substr

Azerbaijan-country

SELECT 1

insert into "Table" values 
  ('---Thee-hyphens-before-and-two-after--'),
  ('------')--6 dashes/hyphens, so it should return only one
returning regexp_substr("column",'([^-]*-){3}(.*)(-[^-]*){2}', 1, 1, 'i', 2);

regexp_substr

Thee-hyphens-before-and-two-after

-

INSERT 0 2