Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Unanswered: converting several txt's to .csv

    Hi, I have approximately 3000 txt files of the format attached. I'm looking for the simplest way to convert them into one .csv for import into a DB. The field length is determined by the dashes on row 7 (some fields fluctuate in length), the rows before row 7 can be discarded.

    I have to believe their is an easy way. A script that could read the first file, delimit according to row 7, export into a csv and then read the next file.

    I'm a complete newbie.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2013
    Posts
    3

    Attachment

    Guess adding the attachment might help
    Attached Files Attached Files

Posting Permissions

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