This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
param ( | |
[Parameter(Mandatory=$True,Position=1)] $UserName, | |
$SharePath = "\\vsnhq1coap01mes\HomeMDB", | |
$CsvsToSearch = 1 | |
) | |
# From CSV which lists Exchange server for each store, | |
# Create a lookup hash table | |
$StoreServer = @{} | |
Import-Csv -Path "store-server.csv" | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$data = @{} | |
Import-Csv namecity.csv | | |
ForEach-Object { | |
if (-not $data[$_.name]) { $data[$_.name] = @{} } | |
$data[$_.name]["city"] = $_.city | |
} | |
Import-Csv namestate.csv | | |
ForEach-Object { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# An illustration of what does and doesn't slow down Powershell and why | |
function Get-LotsOfData { | |
param ( | |
$Rows = 10000 | |
) | |
# $OneK is a 1024-character string that is just the alphabet repeating | |
$OneK = ( 0..1023 | ForEach-Object { [char](65 + $_ % 26) } ) -join "" | |
1..$Rows | ForEach-Object { | |
# Emit the equivalent of one row of a CSV with 5 columns |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$Data = 1..10 | ForEach-Object { | |
New-Object psobject -Property ([ordered]@{ | |
Col1 = (Get-Random -Maximum 1000) + 1 | |
Col2 = (Get-Random -Maximum 1000) + 1 | |
Col3 = (Get-Random -Maximum 1000) + 1 | |
Col4 = (Get-Random -Maximum 1000) + 1 | |
Col5 = (Get-Random -Maximum 1000) + 1 | |
}) | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Function Get-Fibonacci { | |
# Function yoinked from http://blogs.technet.com/b/heyscriptingguy/archive/2010/03/07/hey-scripting-guy-march-7-2010.aspx | |
Param([int]$max) | |
For($i = $j = 1; $i -lt $max) { | |
$i | |
$i,$j = ($i + $j),$i | |
} | |
} | |
Function Get-Stats { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1..5 | ForEach-Object { | |
$out2 = New-Object psobject | |
$out2 | add-member noteproperty Name "Hi" | |
$out2 | add-member noteproperty Username "There $_" | |
$out2 | Format-Table -AutoSize | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Refactored from https://www.reddit.com/r/PowerShell/comments/44zkff/simple_script_for_looking_through_text_files_for/ | |
# Lots of comments explaining changes removed. Look at the revision history in Gist or the commit messages in git for explanations. | |
param( | |
[string] $LogDirectory = "C:\Projects\Patterns\Reports\Run01\logs", | |
[string] $ResultFileDate = ("Results_{0}.csv" -f (MyDate)), | |
[string] $ExtractedFilePath = "$($LogDirectory.TrimEnd('\'))\$($ResultFileDate)", | |
[Array] $patterns= @( | |
',vsftp ,Connection closed.' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# In reply to https://www.reddit.com/r/PowerShell/comments/46bwtd/help_with_counting_in_csv_files/ | |
# Tested against test csvs generated by the other script in this gist, and it worked without modification! | |
param ( | |
$Path = ".", | |
$OutFile = "C:\temp\countlines.csv" | |
) | |
Get-ChildItem -Filter *.csv -Path $Path -Recurse | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# In reply to comment https://www.reddit.com/r/PowerShell/comments/47wc3x/ive_been_asked_to_come_up_with_35_questions_to/d0g8bgd | |
$Hash = @{ | |
"a" = 5 | |
"b" = 4 | |
"c" = 3 | |
"d" = 2 | |
"e" = 1 | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Selected hand-copied text from https://www.youtube.com/watch?v=FjhRkfAuU7I#t=2035 | |
// Article at https://databricks.gitbooks.io/databricks-spark-reference-applications/content/twitter_classifier/index.html | |
// references this video, but the provided code is different than video. | |
// The video does a bunch of stuff to obtain and process the tweets, but | |
// what "val texts = " becomes is simply an array of strings, so I just | |
// made a text file with one log entry per line (I'm trying to classify logs) | |
// and did something like: | |
val texts = sc.textFile("input.log") |
OlderNewer