Could I get a regexp_substr pattern that is looking for the characters after the second '-' and before the third '-'

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems that the users are discussing the use of REGEXP_SUBSTR, a function in Oracle SQL that allows for complex pattern matching. However, none of the conversations provided a specific pattern that matches the characters after the second '-' and before the third '-'. In Oracle SQL, you can use the REGEXP_SUBSTR function to extract the substring between the second and third hyphen. Here is an example:

sql
SELECT REGEXP_SUBSTR('your-string-here', '(.*?-.*?)-(.*?)-', 1, 1, NULL, 2) FROM dual;

In this pattern,

(.*?-.*?)-

matches any characters until the second hyphen, and

(.*?)-

matches any characters until the third hyphen. The

1, 1, NULL, 2

parameters tell the function to start at the first character, find the first occurrence, and return the second group (the one in the second set of parentheses). Please replace 'your-string-here' with the string you want to apply the pattern to. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******