Extract to Excel

[MaCgyver 0]

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

[smartee 14]

hi,

The _Excel* functions, FileRead(), StringRegExp() should get you started. Check them out in the helpfile.

Hope this helps,

-smartee

[MaCgyver 0]

hi,

The _Excel* functions, FileRead(), StringRegExp() should get you started. Check them out in the helpfile.

Hope this helps,

-smartee

I appreciate the help. Thanks!