×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

REGEXP till specific word

0
0
 
0
Language: SQL
Posted by: Jenya Mia
Added: Jan 27, 2021 11:17 PM
Views: 4710
Tags: no tags
  1. .+?(?=November, 2020)
  2.  
  3. regexp_substr(extractvalue(xmltype(os.dataxml),'//StrategicComp_Application/StrategicComp_Transaction/DocumentMetadata/DocumentTitle')
  4.                                               ,'^(.*?)( November, 2021)', 1, 1, 'i', 1) || ' January, 2021').getClobVal()

Write a comment

To post comments, please log in or register.