Results 1 to 4 of 4

Thread: Insert 3 fields into a text file automically

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2000
    Location
    N.Ireland
    Posts
    651

    Question Insert 3 fields into a text file automically

    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.
    Attached Files Attached Files
    Gilly

  2. #2

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2000
    Location
    N.Ireland
    Posts
    651

    Talking

    please help !!!
    Gilly

  3. #3
    Frenzied Member blindlizard's Avatar
    Join Date
    Feb 2001
    Location
    Austin, TX - United States of America
    Posts
    1,141
    If you are inserting it into a database, why not add the information to the database directly insted of the txt file?
    I drink to make other people more interesting!
    [vbcode]On Error GoTo Bar[/vbcode]
    http://www.monsterlizard.com

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2000
    Location
    N.Ireland
    Posts
    651
    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

    Any ideas?
    Gilly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width