Sorry about that last post, it's a little ugly. I didn't expect it to expose all of the RTF code.
Here it is again:
Check this out:
SELECT REGEXP_SUBSTR( '001.069012...3301', '([^.]*)(.|$)', 1, 5, NULL, 1 ) RESULT
This only works on 11g.
If you are on 10g, use this:
SELECT RTRIM( REGEXP_SUBSTR( '001.069012...3301', '[^.]*(.|$)', 1, 5 ), '.' ) RESULT
Found at: newbielink:http://forums.oracle.com/forums/thread.jspa?messageID=9530500� [nonactive]
The key (best) response where this code is listed is by Solomon Yakobson on Apr 19, 2011 11:48 AM.