MaCgyver

Ok thanks guys.

I know there are apps out there that do this, but will they do in this manner. Need to check txt files in the same directory. There is a small variation that I don't want to be checked for. So basically the app to pick the first file then compare against the other files in the directory. If there is a match to notify. If not then proceed until all files are compared against the first file. Then go to the second file can compare against all the files in the directory as well.

I appreciate the help. Thanks!

I have about 50 thousand files I have to extract data from. The first column in the excel sheet would be the name of the file the data for that row is being extracted from. The format of the data I am focusing on looks like "Your item was delivered at 2:15 pm on April 08, 2011 in MIAMI, FL 33146.". I then need to place "delivered", "April 08, 2011" and "Miami" into a row in excel, along with the name of the file in the first column of the row. The fields (noted in quotes) will vary. Delivered could be "refused" or "notice left". And the data in the date, City&State and Zip field will change. I think I need to use the stringinstr function. Any other function you think are needed for me research would be helpful. Thanks

yes..thats why i took off what i said but you got it before I could. its 4:40am my time and I've slept maybe 4 hours a night for the past two weeks. Thanks for what you wrote and I will be sure to be fully awake before I look at code and make a comment. Once again thanks!

Thanks. Looks a lot cleaner. Will try it out in a few.

Thanks for the direction. Going to work in the search part (I can manually do for now). However I got the write to excel part done. If anyone can make the code shorter or more efficient, please advise. Thanks [#include <Excel.au3> ; Shows the filenames of all files in the current directory. $search = FileFindFirstFile("*.*") $i = 0 Local $oExcel = _ExcelBookNew() ;Create new file, make visible ; Check if the search was successful If $search = -1 Then MsgBox(0, "Error", "No files/directories matched the search pattern") Exit EndIf While 1 $file = FileFindNextFile($search) If @error Then ExitLoop $i = ($i + 1) MsgBox(4096, "File:", $file);show name before writing to cell _ExcelWriteCell($oExcel, $file, $i, 1) ;Write to the Cell WEnd ; Close the search handle FileClose($search)]

It's been a few years so I'm working off the cob webs. Not that I was ever that great, but I was getting into the swing of it. Looking through the helpfile, but fatigue is probably got my brain fried. Anyway looking to Search for a specific word within a group of .txt files. Once they are located the file(s) name(s) get copied into Excel. What function should I be looking at?

Thanks.... I was actually looking for winhttp in my helpfile but learned that its a UDF that I can get off of here.

What version is this included in?

Looking in the helpfile, but I guess I am overlooking something. Need to be able to copy text from a webpage and paste into a text file. The site url is http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do and once tracking number is loaded it displays info/text that I need to copy.

Couldn't work on this like I planned during the day. Will hop on this soon as I get home.

Another site that this will be used for USPS.com

Understood...and thanks. I'm just doing so much already that I was willing to get this done quicker.

ups.com Thanks for the info!!! This should get me going. However if you want to make a little cash, PM me.