Capture details in multiple files into Excel sheet?

PsychomIKE · 22 Oct 2010 at 13:06

Hi, hope this is the right forum.

I have to capture details of customers of ours from within hundreds of files across several different folder levels and put them in a spreadsheet - details are ContactName, ContactEmail and CompanyName.

Is there an automatic way of doing this?

Thanks

PsychomIKE · 23 Oct 2010 at 13:15

Same file extension but different directories and directory levels.

PsychomIKE · 23 Oct 2010 at 14:59

Yeah, 1 time only thing. I can't check right now but I think the files should all be identical (they're essentially renamed text files).

PsychomIKE · 24 Oct 2010 at 19:51

Hi guys, cheers for helping out with this. You're knowledge far surpasses mine

chaosphy has pretty much nailed the format of the files though I wouldn't know where to begin with implementing your suggestions. Excel idiot here!

PsychomIKE · 24 Oct 2010 at 20:00

Sorry

Not in the office at the weekend but I'll do it tomorrow morning

PsychomIKE · 25 Oct 2010 at 08:57

Well here is an example...

ContactName Joe Bloggs
ContactEmail [email protected]
ContactPhone 556 556 990
ContactFax
CompanyName Joe Bloggs Inc

There's much more in the file but that is the top section and all we're intersted in. Thanks!

PsychomIKE · 25 Oct 2010 at 09:20

That's exactly how it is.

PsychomIKE · 25 Oct 2010 at 14:00

They are text files renamed .PFL and the data is in numerous files across numerous directories.

i.e.

6453654272joebloggs.pfl
5427542772johnsmith.pfl
4324988903jondoe.pfl

PsychomIKE · 25 Oct 2010 at 14:17

PsychomIKE · 25 Oct 2010 at 17:36

Sure, don't see why we couldn't copy all of them to 1 folder.

PsychomIKE · 26 Oct 2010 at 17:12

Hey, thanks guys!

chaosphy - I tried that as a bat file though it had a few issues. At least some company names only had the second part of the name. There may be more but I didn't have any time to spend on checking this out. Hopefully will tomorrow.

A[L]C - That seems great! Didn't notice any errors but again not had much time. Could you also add CompanyName CompanyAddress CompanyCity and CompanyState? The delimeter is CompanyZip and anything from there isn't needed.

Will def reread what you both posted though so I can do this myself next time

PsychomIKE · 26 Oct 2010 at 21:37

No, I don't need that right now. That's the end of wanted data really.

I did try adding these myself in your vB but kept getting debug errors. I'd tried to logically expand the system you had but no success.

PsychomIKE · 27 Oct 2010 at 09:23

Ahh, I see what's going on.

The first delimiter is a tab and not a space - I guess the forum formated that when I copied it though I should have noticed.

How can I change that in your file chaosophy?