3 Replies Latest reply on Jan 17, 2013 11:33 AM by asahide

    Editing Control File

      Hi, i currently have a control that loads data from a text file into the required table. What I have noticed within the text file is that this has a value on the last row of how many rows of data the file has and this row is being added within the database and the rest of the fields than have null values.

      Is there anyway I can write something within the control file to exclude this part from the text file, this would make it easier than me opening the text file and removing the values on 10 files everyday.

      If somebody could please advise.