MaCgyver 0 Posted May 21, 2011 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 Share this post Link to post Share on other sites
smartee 14 Posted May 21, 2011 hi, The _Excel* functions, FileRead(), StringRegExp() should get you started. Check them out in the helpfile. Hope this helps, -smartee Share this post Link to post Share on other sites
MaCgyver 0 Posted May 21, 2011 hi,The _Excel* functions, FileRead(), StringRegExp() should get you started. Check them out in the helpfile. Hope this helps,-smarteeI appreciate the help. Thanks! Share this post Link to post Share on other sites