in reply to Pattern matching "dirty" data sources

What is it you're trying to accomplish? There are several better ways, but it all depends on where you're trying to go.

------
We are the carpenters and bricklayers of the Information Age.

Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

  • Comment on Re: Pattern matching "dirty" data sources

Replies are listed 'Best First'.
Re: Re: Pattern matching "dirty" data sources
by Anonymous Monk on Apr 30, 2003 at 19:07 UTC
    I want to create a report listing:

    - all tables and views created in a script

    - all the used tables and views in a script

    for each script file we use to create the databases. Probably 50-80 scripts and around 40K LOC.

    My first approach is to parse the script file and extract the names from the create statements and the from clauses. Maybe there's a better way?

[reply]

In Section Seekers of Perl Wisdom