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.