This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler 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


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
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 ?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regular expression - count newline characters
 
It's not a secret anymore!