MaCgyver Posted May 21, 2011 Share 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 Link to comment Share on other sites More sharing options...
smartee Posted May 21, 2011 Share Posted May 21, 2011 hi, The _Excel* functions, FileRead(), StringRegExp() should get you started. Check them out in the helpfile. Hope this helps, -smartee Link to comment Share on other sites More sharing options...
MaCgyver Posted May 21, 2011 Author Share 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now