Archives of the TeradataForum
Message Posted: Mon, 07 Mar 2005 @ 16:09:59 GMT
| Subj: || || Re: Extracting names from a CLOB column |
| From: || || Victor Sokovin |
| ||My client wants to investigate possible ways to search a text document stored in a CLOB column and extract the names of people that appear
in it into a VARCHAR column. Has anyone had any experience implementing such an application using a UDF, text mining or other software?|| |
Other software. Namely, Oracle OWA_PATTERN package. It seems to be doing the job and offers all usual search and replace functionality based on
regular expressions. I had no problems with it on small volumes but still have to see how it behaves when volumes increase.