Regular Expression Conversion

• kumaran22

  SSC Enthusiast

  Points: 174

  More actions

  July 29, 2019 at 4:00 pm

  #3666891

  Hello,

  How do i convert the following piece of code in SQL Server? What can i use in SQL Server in place of REGEXP_SUBSTR and INSTR?

  INSTR(REGEXP_SUBSTR (URI, '/([[:alnum:]]+(/|?){3}){1,2}'),'/',1,3) > 0

  Thanks

• drew.allen

  SSC Guru

  Points: 76997

  More actions

  July 29, 2019 at 9:58 pm

  #3666967

  Try posting your question in English rather than whatever computer programming language this is.  Be sure to include sample data and expected results.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA