Re: newbie: examples of regular expressions in oracle?

I found a decent enough hack on Ask Tom at oracle.

but I don't understand when you say that you cannot reliably edit html using REs. I've done it for 8 years in ColdFusion and CF had a lousy implementation of REs for years. I'm managing a few legacy apps written in PERL that make massive use of REs to share data from webpages (think of it as proto-RSS) that have been running for 10 years- and they're constantly working with pages that change text, values, tags, etc. I've never run into errors in identifying HTML tags in REs and can't imagine how there would be a problem since they're so easily identifiably and HTML ALWAYS follows the same patterns- it's the quintessential RE example.

Don

Malcolm Dew-Jones wrote:
> bbcrock_at_hotmail.com wrote:
> : thanks.
>
> : I researched this and found lots of issues w/ regex in oracle 8i.
>
> : Unfortunately the html tag attributes vary on this one. I ran a
count
> : and there are 41 records to modify, which isn't an impossible task.
 I
> : will see if anyone has some hacks on Replace that could work.
>
>
> In a perl group it would be pointed out that you cannot reliably edit
html
> using regular expressions.
>
> To tie that to Oracle, my own approach, which may not help you, would
be
> to use perl, with DBI, to extract the data from oracle, HTML::Parser
to
> help cut/chop/splice/dice the html in perl, and then use DBI to put
the
> result back into the Oracle database.
>
> On a PC, Perl 5.6 from active state is trivial to install, and if the
PC
> has oracle installed then it is also trivial to use PPM to install
the
> Oracle DBD so perl can speak to oracle. (note 5.6, not 5.8 which
requires
> other steps to speak to oracle).
>
> Of course that assumes you know enough perl to make it worthwhile to
go
> that route at all.
>
> (And I suppose Java could be used in a similar way using JDBC).
>
>
> --
>
> This space not for rent.
Received on Sun Mar 13 2005 - 11:38:21 CST