Function to parse out lines in a memo field

[dkwong]

Does anybody know if there is a function in Oracle equivalent that can parse out lines in a memo field? I want to take in a field that contains multiple lines separated by line breaks and return a specific line or return the number of lines in the field. What's the best way to do this?

i.e.
MLINE(<memo field>, <nth line>)
MEMLINES(<memo field>)

 

[carp]

I don't think there's one. However, it shouldn't be too hard to write a couple of functions to do what you're after.