aspose file tools*
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
Author

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 ?
 
Don't get me started about those stupid light bulbs.
 
subject: Regular expression - count newline characters