Results 1 to 1 of 1

Read multiple Text files

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    w
    MS-Off Ver
    Excel 2010
    Posts
    18

    Read multiple Text files

    Hi,

    I will need to read from a folder with text files inside that are with the extension ".ke3". The files are named 11112222_X. Its incrementing up to an X number which varies for every folder, sometimes its upto 100 sometimes its upto 900.



    ScreenHunter_06 Apr. 14, 2014 - Copy.jpg
    This file is read because of the word "Birthrecord." Read this and get the total amount of records per file and include on the other column the last input on the text file which in this case is "janet" It should go to the next line for the next files it reads.

    It should look like this
    004885317_00014 4 janet





    ScreenHunter_07 Apr. 14, 2014.jpg
    Do not count files that do not have the "birthrecord" caption- it can be any other word on that column in this case "titleboard" or it could be a "capture" or any other word other than "birthrecord"
    This is how should it should read this
    004885317_00001 0 janet
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Read multiple text files into a Spreadsheet
    By fatti in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2012, 10:13 AM
  2. [SOLVED] Read two text files without opening and write to another
    By amotto11 in forum Excel Programming / VBA / Macros
    Replies: 56
    Last Post: 08-30-2012, 04:04 PM
  3. Read Multiple Text Files to ListBox
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2012, 02:31 PM
  4. Macro code to read multiple text files
    By sathik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2012, 03:42 AM
  5. To read many text files and write it in the excel file
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-16-2009, 01:51 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1