This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Regular expression - count newline characters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regular expression - count newline characters" Watch "Regular expression - count newline characters" New topic

Regular expression - count newline characters

Ashish Shinde
Ranch Hand

Joined: Dec 08, 2002
Posts: 34

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 ?
I agree. Here's the link:
subject: Regular expression - count newline characters
It's not a secret anymore!