Results 1 to 9 of 9

Thread: Extract Text, Sent to Excel File

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2006
    Posts
    5

    Extract Text, Sent to Excel File

    I am a bondsman, and I have a text file that is sent to me, sometimes daily. It is in the format of a text file. The problem for me is that each record is 3 or 4 lines deep. I would like to export the data from this text file into an Excel worksheet.
    The way the report comes to me currently isn't user friendly the way that it is.

    I am expecially interested in the following items.
    from the 1st record:

    File Number: 06CR 052172
    Defendant Name: Xxxxx,Xxxxxx,Xxxxxx
    Bond: $2,000 Sec

    There may be as many as 300 records to pull this data from.
    It is always laid out in this manner. I can not change this.
    Thanks for your help.
    titans25
    I have attached a small sample of the file as I receive it.
    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
  •  



Click Here to Expand Forum to Full Width