Each day i receive multiple ASCII text files containing important information. I place these text files in a directory on our server.
I need to be able to write a program which will edit each text file by adding 3 additional fields at the beginning of each record. These additional fields are called dept, route and load type.
Ive attached an asp program which i currently run to import the current data from the text file into a access database. It works well, however can anyone help me write a program to automatically insert three additonal fields to the text file before inserting into the database.
No, i need to write a program to insert the 3 new fields into the text file. I want to transfer the updated file to a new location on my server after the insert is complete. I will no longer be using a database.
FIELD START POSITION LENGTH
Route code 381 8
Load type 389 8
Department 397 5