• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regular expression - count newline characters

 
Ashish Shinde
Ranch Hand
Posts: 34
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have a requirement to count the number of newline characters in a varchar2 field in Oracle.
The catch is if the line starts with characters 'SS' it should be ignored in the count.

E.g.: -


should return the count as 3

Is there a way to do this using regular expression ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic