comparing data between files

[rlee80]

Hi,

I have 2 files, a data file containg stats from an email server log which contains usernames and mails in and out of the company,

I have a cross reference file containing mailbox names, aliases and departments.

I need to check that the usernames in the data file equal an alias or username in the cross reference file then with that name correct extract the stats (mails in and out) from the data file together with the username and create a new file with a name based on the users department containing all the stats for those users!

data file is in this format

[someone@internal.mail]
attchin2=13
attchout=0
bytesin2=273370
bytesout=0
filesin2=13
filesout=0
L010Kin2=2
L100Kin2=1

and the cross reference files is in this format

jbloggs=joe.bloggs(bloggs, joe)CSdepartment{#joe.bloggs^#jbloggs^}jblogs[8377#bloggs,joe@bloggs~

anything between # and ^ is an alias

I need a lot of help as I am going round in circles or could that be loops I have some basic knowledge and I suppose I am looking for som pseudo code

Thanks

Rob

 

[PHV]

And what have you so far ?
Take a look at FileSystemObject (fso).
You may consider a Dictionary object storing info from the cross reference file for easy search.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244