Toad World® Forums

delete 1st line of text file in an automated job

Hello,

I have created a procedure to extract and update a table. I added the Procedure into a job , and the next step is to extract the data from that table into a text file with pipe delimited fields. What I cant find is how to delete the 1st line of the text file.

example:

line1: 1
line2: 14466869-99999-2|1|

Thank you !

I do not understand your issue.

Can you post the DDL for the table along with insert statements to populate the values in the first several rows of that table.

Then we can investigate extracting from that table a bit on our side.

Thanks.