How to get the whole line up to the second double slash (//)
Example text: "C#//text with any symbols */\ even digits 97878//Other don't need text".
I would get "C#//text with any symbols */\ even digits 97878"
I tried to user ^[^\/]*\/\/[^\/]* but any slash spoils everything.
Thanks!
You said:
How to get the whole line up to the second double slash (//)
If that's so, you don't need regular expressions; substr + instr combination is capable of doing it:
SQL> with test (col) as
2 (select 'C#//text with any symbols */\ even digits 97878//Other don''t need text' from dual)
3 select substr(col, 1, instr(col, '//', 1, 2) - 1) result
4 from test;
RESULT
-----------------------------------------------
C#//text with any symbols */\ even digits 97878
SQL>
instr(col, '//', 1, 2) says:
col in this example) for double slash // 1st position in a string2nd appearance@Littlefoot answer using SUBSTR and INSTR is the simple (and best) solution, but if you want to use regex you could use REGEXP_REPLACE to remove everything after and including the second //:
with test (col) as
(select 'C#//text with any symbols */\ even digits 97878//Other don''t // need text' from dual)
SELECT REGEXP_REPLACE(col, '^(.*?//.*?)//.*$', '\1') result
FROM test
Output:
RESULT
C#//text with any symbols */\ even digits 97878
Demo on dbfiddle (including @Littlefoot answer)
If you really want to do it with a regular expression you can use
REGEXP_SUBSTR(TEXTVAL, '(.*\/\/.*)\/\/', 1, 1, NULL, 1)
^.*?//.*?(?=//)? regex101.com/r/oOCSE5/3/^.*?\/\/.*?(?=\/\/)/(taking into accound that in the question they are backslshed)./delimiters around the regex..*?construction for??seem to be redundant.?makes.*lazy without it the first.*will match to the second to last//if there is a third (or fourth or ...)//in the string (try removing the?in my demo link and you'll see what I mean)