Data :- 1,2,3=20,4,5
select regexp_substr(data,',3=[^,]*')
output = ,3=20
Desired output = 20
How do I get rid of,3=? I can add split_part(regexp_substr(Data,',713=[^,]*'),'=',2)
but using the same expression would make sense.
Thanks
Advertisement
Answer
You can extract a pattern using a subexpression:
select regexp_substr(data, ',3=([^,]*)', 1, 1, 'e')