SQL Loader + report ++headline+footnote+logical record

"SQL*Plus: Release 8.0.6.0.0

The report looks like this:

two lines make a headline, the first line has an 'ACCOUNT' string in the front
records have a '/' character at 88th position one line makes a footnote there is a ':' character at 52nd position

A report sample:

' ACCOUNT' headline1
headline2
record1
record2
..
recordn
footnote

(And there are pageheaders and blank lines+reportheader in it.)

records in the table should look like this:

headline1 headline2 record1 footnote
headline1 headline2 record2 footnote
headline1 headline2 ....... footnote
headline1 headline2 recordn footnote

I think it is impossible to import it with SQLLoader.
(I could not even substract the headline(headline1+headline2).
If use continueif this (1:8)=' ACCOUNT', then it concatenates two lines, but i also have filter it and with when (1:8)=' ACCOUNT' because of headline2 (' ') the whole logical record is rejected.) What do you think about it?
If you can solve it please send me an email. Received on Wed Nov 22 2000 - 03:14:28 CST