Re^2: Oracle report converter

ok I got ..thnx for the precious reply but please guide me if the file can have lot of commands like

- .define
            - .declare
            - #nc
            - #t
            - #s
            - .ifnull
            - .print
            - ..
            - #dt
            - .set
            - .&[something]
            - .execute
            - #cl
            - #
            - .if
            - [chars]
            - #r
            - .[defined]
            - .stop
            - .commit
            - #cen
            - #cs
            - .report
            - #n
            - ( [stuff] )
            - .goto
            - #te
[download]

So Do I need to parse each and every line of the file?

Comment on Re^2: Oracle report converter Download Code

Replies are listed 'Best First'.
Re^3: Oracle report converter by CountZero (Bishop) on Jun 25, 2007 at 19:40 UTC
(Assuming the above is part of the `.rpt` file) Yes, you will have to go through the whole of the file unless you can tell beforehand that certain parts can be skipped as they contain no information you need (such as comments and the like). Searching on the WWW, I found the following in an Oracle Glossary: RPT / RPF Report writing and formatting tools provided with older desupported releases of Oracle. The RPT process queried the database, producing rows of data with embedded formatting commands recognized by RPF. What you are actually trying to do is to re-invent the functionality of the Oracle RPT / RPF process. I know nothing of Oracle, but it looks to be a tall order to me! CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Oracle report converter
by CountZero (Bishop) on Jun 25, 2007 at 19:40 UTC

.rpt

Yes, you will have to go through the whole of the file unless you can tell beforehand that certain parts can be skipped as they contain no information you need (such as comments and the like).

Searching on the WWW, I found the following in an Oracle Glossary:

RPT / RPF
Report writing and formatting tools provided with older desupported releases of Oracle. The RPT process queried the database, producing rows of data with embedded formatting commands recognized by RPF.

What you are actually trying to do is to re-invent the functionality of the Oracle RPT / RPF process. I know nothing of Oracle, but it looks to be a tall order to me!

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

[reply]
[d/l]