Post reply

Inserting a header and footer in a txt file export

  • June 24, 2002 at 7:19 pm

    #158585

    Hi,

    I am using the multiphase data pump export data into a delimited text file. I need to insert a header and footer into the text file.

    The number of fields in the header/footer doesn't match the no in the records, so I can't use a union!

    My gut is telling me to stick some vbscript in the pre- & post-source phases of the pump. Unfortunately what to put in escapes me - can anyone point me in the right direction?

    Thanks in anticipation!

  • June 25, 2002 at 5:07 am

    #431559

    I believe you can do this with VBScript after you output the data to text file. Open in VBScript using FileSystemObject and TextStream (Lookup both at http://msdn.microsoft.com . You can specify a position to write to so you can insert your header and your footer to the file after created.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply