Re: Translating SGML files to SQL*Loader files

In article <326E228C.41C6_at_tripos.com>, Donna Triebe <donna_at_tripos.com> wrote:
>I have several large SGML files that I would like to translate into
>SQL*Loader files so that I can load the data into an Oracle database.
>
>Has anyone done this before? Is there a tool out there that can help
>me translate the SGML files?

i did this several years ago. the job requires a filter smart enough to read the tags and direct their content with keys into the desired tables.

the job is complex if the text is truly content-modelled for then the tags may be embedded anywhere. as a result you cannot specify it in sqlloader scripts.

if the tags were machine-generated to begin with, they may occur in a very regular, predictable manner, which might make a sqlloader solution possible. but that's a very unlikely scenario.

i wrote custom c programs, and i have also used the snobol language which is specifically designed for text processing. you could write awk scripts, too. i know of no cheap generic solution that accepts a DTD and text, and outputs data into tables.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.