Hi

I need to create a script to count the number of occurances of files where the email address in the file name is the same.

Here is an example of a file name:

w_user@email.com_XID22Y42135F29r_Doc1.pdf

The email address is always between 'w_' and the second '_' in the filename.

What is the best way to do this?

Thanks

Rob

Assuming your pattern remains the same:
PS>dir *.pdf|group {$_.name.split("_")[1]}

Thanks Marco. That worked great!

How would I deal with an email address in the filename that had an underscore (user_1@email.com). See example below:

w_user_1@email.com_jhfklhsf_Doc1.pdf

Cheers

Rob

I hate regular expressions! That's going to be a bit more complicated, and I'm not able to figure it out right now.

try this

dir -name | group {$_ -replace '^(.+@.+_.+)_.+$','$1'}

Thanks Shay

I tried your suggestion but I couldn't get it to group correctly. This is my script that Marco helped with:

dir "C:\Test" *.pdf|Where-Object {($_.lastwritetime -ge "08/01/2010" -and $_.lastwritetime -lt "08/25/2010")}|group {$_.name.split("_")[1]}

It works OK until the email address contains an underscore then it just groups by the characters between the first and second underscores. The example file below groups by 'user' instead of 'user_1@email.com'

w_user_1@email.com_jhfklhsf_Doc1.pdf

What is the best way to use you suggestion with the date filter I used above?

Does this work?

dir "C:\Test" *.pdf|Where-Object {($_.lastwritetime -ge "08/01/2010" -and $_.lastwritetime -lt "08/25/2010")} | group { $_.Name -replace '^(.+@.+_.+)_.+$','$1' }

Thanks Shay

The new code is grouping but not by the email address. The file name still includes the 'w_' at the front and '_' + characters to the right of the email address.

Heres an example:

Orginal file names
w_user@test.com_XID1au20v139Y6L_L62.pdf, w_user@test.com_XID1au20v139Y6L_L63.pdf, w_user@test.com_XID1au20v139Y6L_L64.pdf

Result
Name                                                             Count
---------                                                         ----------
w_user@test.com_XID1au20v139Y6L          3

Rob

try this pattern:

'^(.+@[^_]+)_.+$','$1'

Thanks for your help Shay. The grouping and counting seems to be working ok now. Could you please tell me how would I would remove the 'w_' from the front of the Name object that is returned?

Rob

Change the regex pattern to the following:

PS > 'w_user@test.com_XID1au20v139Y6L_L64.pdf' -replace '^w_(.+@[^_]+)_.+$','$1'
user@test.com

Thanks Shay. That worked perfectly!

Cheers
Rob