Re: owa_pattern question

Hello,

here are the tokens for owa_pattern:

Tokens
The wildcard tokens that are supported are as follows:

^
Matches newline or the beginning of the target.

$
Matches newline or the end of the target.

\n
Matches newline.

.
Matches any character except newline.

\t
Matches tab.

\d
Matches digits [0-9]

\D
Matches non-digits [not 0-9]

\w
Matches word characters (alphanumeric) [0-9, a-z, A-Z or _]

\W
Matches non-word characters [not 0-9, a-z, A-Z or _]

\s
Matches whitespace characters [blank, tab, or newline]

\S
Matches non-whitespace characters [not blank, tab, or newline]

\b
Matches "word" boundaries (between \w and \W)

\x<HEX>
Matches the value in the current character set of the two hexidecimal digits.

\<OCT>
Matches the value in the current character set of the two or three octal digits.

\
Followed by any character not covered by another case matches that character.

hope this helps
cheers
Gerald

Mark Aurit wrote:

> Hi
> Im capturing text from an internet app into a varchar column;
> eventually, that text is written out to a flat file which is batched
> into another system. Written in PLSQL, on OWS 3.x,
> its been working fine
> Recently, we found that a user had input a tab character,
> which made it to the flat file, which threw off the offsets
> and caused the batch to bomb; so I need to do some pattern
> matching using the owa_pattern package.
> Problem is, Im finding no documentation on how to match
> for special characters. Can anyone help?
> Thanks, Mark
Received on Thu Oct 21 1999 - 16:50:37 CEST