group them

Friday, December 07, 2007 7:44:57 PM
Tuesday, December 04, 2007 8:28:44 AM
Monday, December 10, 2007 12:21:33 PM
Friday, December 07, 2007 4:27:27 PM
Wednesday, December 05, 2007 11:15:31 AM
Monday, December 10, 2007 2:07:07 PM
Tuesday, December 04, 2007 9:19:57 AM
Sunday, December 09, 2007 5:31:06 PM
Wednesday, December 05, 2007 10:10:24 AM
Tuesday, December 04, 2007 3:56:20 PM

=========================================
You can assume the above is already in variable $files

foreach ($f in $files) ....

Each item is a row. How can i group by dates in this format with a count ?
Eg Dates = total count

December 04 2007 = 3
December 07, 2007 = 2
December 05, 2007 = 2
December 09, 2007 = 1
December 10, 2007 = 2

You can pipe them to group-object

PS > $d1=$d2=$d3 = get-date -year 2007 -month 12 -day 1
PS > $d4=$d5 = get-date -year 2007 -month 11 -day 1
PS > $d1,$d2,$d3,$d4,$d5 | group

Count Name Group
----- ---- -----
3 01/12/2007 09:56:53 {01/12/2007 09:56:53, 01/12/2007 09:56:53,
01/12/2007 09:56:53}
2 01/11/2007 09:56:53 {01/11/2007 09:56:53, 01/11/2007 09:56:53}



Group by formated date:

PS > $d1,$d2,$d3,$d4,$d5 | group {$_ -f "MM/dd/yyyy"}


Count Name Group
----- ---- -----
3 01/12/2007 09:49:40 {01/12/2007 09:49:40, 01/12/2007 09:49:40,
01/12/2007 09:49:40}
2 01/11/2007 09:49:40 {01/11/2007 09:49:40, 01/11/2007 09:49:40}



Group by property name (e.g day, month etc):

$d1,$d2,$d3,$d4,$d5 | group -property {$_.Month}

Count Name Group
----- ---- -----
3 12 {01/12/2007 09:56:53, 01/12/2007 09:56:53,
01/12/2007 09:56:53}
2 11 {01/11/2007 09:56:53, 01/11/2007 09:56:53}






-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Hebrew weblog: http://blogs.microsoft.co.il/blogs/scriptfanatic

On Dec 17, 7:05 am, "IT Staff" <jkk...@xxxxxx> wrote: Create a RegEx to separate the date and time parts, then using the
date-part to access a hash-table, increment a counter. When done,
print the list of keys along with the incremented counter.

HTH,

Duncan

Sorry, I misinterpreted the question. Here's a sample regex parsing:



$a="Friday, December 07, 2007 7:44:57 PM",
"Tuesday, December 04, 2007 8:28:44 AM",
"Monday, December 10, 2007 12:21:33 PM",
"Friday, December 07, 2007 4:27:27 PM",
"Wednesday, December 05, 2007 11:15:31 AM",
"Monday, December 10, 2007 2:07:07 PM",
"Tuesday, December 04, 2007 9:19:57 AM",
"Sunday, December 09, 2007 5:31:06 PM",
"Wednesday, December 05, 2007 10:10:24 AM",
"Tuesday, December 04, 2007 3:56:20 PM"



$group = $a | foreach { ([regex]'([A-za-z]+\s[0-9]+,\s[0-9]+)').match($_).value
}
$group | group

Count Name Group
----- ---- -----
2 December 07, 2007 {December 07, 2007, December 07, 2007}
3 December 04, 2007 {December 04, 2007, December 04, 2007, December
04, 2007}
2 December 10, 2007 {December 10, 2007, December 10, 2007}
2 December 05, 2007 {December 05, 2007, December 05, 2007}
1 December 09, 2007 {December 09, 2007}


$total=0
$group | group | foreach {$total+=$_.count}
$total

10





-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Hebrew weblog: http://blogs.microsoft.co.il/blogs/scriptfanatic


PS>> $d1=$d2=$d3 = get-date -year 2007 -month 12 -day 1 $d4=$d5 =
PS>> get-date -year 2007 -month 11 -day 1 $d1,$d2,$d3,$d4,$d5 | group
PS>>

How do i convert $a into a string array ?

I mean how do i join the string into one $a





"Shay Levi" <no@xxxxxx> wrote in message
news:8766a94413c8c8ca0eaf1c4bf382@xxxxxx

You can use the [string] join static method

# [string] | gm -st j*
# Join Method static System.String Join(String separator,
String[] value)....

PS> [string]::Join("<separator>",$a)

Friday, December 07, 2007 7:44:57 PM Tuesday, December 04, 2007 8:28:44 AM
Monday, December 10, 2007 12:21:33 PM Friday, December 07, 2007
4:27:27 PM Wednesday, December 05, 2007 11:15:31 AM Monday, December 10,
2007 2:07:07 PM Tuesday, December 04, 2007 9:19:57 AM Sunday, Dece
mber 09, 2007 5:31:06 PM Wednesday, December 05, 2007 10:10:24 AM Tuesday,
December 04, 2007 3:56:20 PM

Isn't $files a string array already?

-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Hebrew weblog: http://blogs.microsoft.co.il/blogs/scriptfanatic

$created = get-date -year 2007 -month 12 -day 1
$files = get-childitem $args[0] | where {!$_.PSIsContainer -and
($_.CreationTime -ge $created)} | select creationtime
foreach ($f in $files)
{

get-date ($f.creationtime)
}

How can i put into $a array ?




"IT Staff" <jkklim@xxxxxx> wrote in message
news:OHbOnEJQIHA.4476@xxxxxx

You can force $files to a string array:

[string[]] $files = get-childitem ... | where ... | foreach{$_.creationtime}



-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Hebrew weblog: http://blogs.microsoft.co.il/blogs/scriptfanatic