Results 1 to 11 of 11

Thread: Reading A Text File [RESOLVED]

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2004
    Posts
    11

    Question Reading A Text File [RESOLVED]

    Hello gents,
    I mainly program in java, in web apps using Dreamweaver and JDeveloper, however I need to put my rusty vb skills back in action. I have comma delimated text file, that looks like this.

    SSN, LAST_NAME, MOS, RANK

    I need to format this comma delimated text file to look like this

    SSN, LAST_NAME, MOS, RANK, FIELD1, FIELD2, FIELD3

    This text file contains over 12,000 records, and I know how this can be done easily with notepad and concatenating the FIELDS onto the end. However this Web application that I am developing requires that this text file be updated More than once a week. The file is used to insert into an Oracle 9i DB. The Field 1,2,3 are fields that are retrieved from a .jsp web page and are filled in for all the 12,000 records in the text file before it is loaded into a database. It would be nice if this was done using a single .exe built in VB. If I can get the file formatted correctly then I can take the inserting into the DB easily. I have seen on the web a lot about FileSystemObjects however I dont know how to use that class in VB. My copy of vb is less than legal, and because of this my MSDN is broken. Any help is apreciated.
    Last edited by IM_MARINE; Aug 13th, 2004 at 10:54 PM.

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