Sign in to follow this  
Followers 0
MaCgyver

Extract to Excel

3 posts in this topic

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



hi,

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

Hope this helps,

-smartee

Share this post


Link to post
Share on other sites

hi,

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

Hope this helps,

-smartee

I appreciate the help. Thanks!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0