Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2015
    Posts
    23
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Search / read text file

    Hi to all,

    I need to read a text file and pull out the specific values located in the text file and then compare it.


    The value i want to access from the text file is formated and never changing, text file line to search [Total For YRCode ---->]


    The spreadsheet Column A contains the primary key to search text file, append the values to Column D and E and then compare column B and D, Column C and E and report any mismatch.

    For more details i have attached the sample text file along with workbook.

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Well, I kinda forced this without trying to condense it. Seems to work. Take a look.
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Apr 2015
    Posts
    23
    Thanks
    11
    Thanked 0 Times in 0 Posts
    Hi,

    Thanks kweaver for helping.

    Infact i am expecting to run macro which will ease to search the text string and without import will pull the value to sheet.
    The text file which is of 10,000 lines, the macro will ask for the location of the text file and run a search scan on the file and append the values.

    Any ideas or codes are welcomed.

    Thanks in advance.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Someone else will have to provide you with the macro. Not my strength. I ran it with 10,000 lines and the approach I used immediately filled the answers.

Posting Permissions

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