This Oracle query: select distinct regexp_replace(My_column,'(-.*$)','')
looks for a hypen and removes the hypen and any text after the hypen.
What I need is to modify this for the search for the hypen to start at character 15.
Any text in characters 1 to 14 needs to be returned as-is.
Example input: abcdef-abcdefg x-gorgumplatz
should return: abcdef-abcdefg x
Any help on this is greatly appreciated.