“Here’s a script for modifying some CSV files I had. It prompts you for the name of the file. (Pretty sure you need to have the script in the same directory). Then it repeatedly asks for what you want replaced and what you want it replaced with. I had a lot of modifications to make so it just keeps asking till you exit the script. You can exit the script by typing exit at the ‘with’ line. With each mod’ it creates a sequence of copies of the orginal file with each subsequent change. (test.csv, test.csv1, test.csv2, etc.) Then it copies the end file after exiting, over the orgin file. Hence if you need the orginal file look for the file (test.csv0 or test.csv1). This is kind of a beta so feel free to improve it… or email me revisions. The one problem I ran into is when changing non-letters/numbers in a document; say I needed to remove quotes from a document. By default it gives me errors. Often you have to type in such characters twice so the Powershell script knows to treat it as a character.. Its a bit of a pain. Enjoy!!

Script below:

#########
#attempt to replace db stuff
$file_id = read-host “”file to modify: “”
$count = 0
$file_not = $file_id + $count
Copy-item $file_id $file_not

#####begin loop
while ($count -lt 700)
{
$file_not = $file_id + $count
$file_new = $file_id + ($count + 1)
$replace = read-host “”Replace”"
select-string -path $file_not -pattern $replace
$with = read-host “”With”"
##archive list of changes
#exit statement
if ($with -match “”exit”")
{
break
}
### log of changes
$change_str = “”$count”" + $replace + $with
add-content -Path change.log -Value $change_str
### actual mod script
### modifies org file with new file based on replace and with
### change.log keeps track of changes count number list prior file
(get-content $file_not) | foreach-object {$_ -replace $replace, $with} | set-content $file_new
select-string -path $file_new -pattern $with
copy-item $file_new $file_id
$count = $count + 1
}”

“This could be real helpful if you have a client who keeps clicking the Print button prematurely. To save on ink, an phone calls, maybe this script could help.

Script:

Get-WmiObject Win32_Printer -computerName “”Computer3″” | Where {$_.Name -eq “”HP LaserJet Professional P1102w”"} | ForEach { $_.CancelAllJobs() }

#End

So for “”Computer3″” put your computer name… An of coarse your default printer where the “”HP”" printer is mentioned. To put a short-cut on the the desktop remember that you need to direct to the powershell.exe. Basically this below in the Target path.

%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe C:\ps_scripts\cancel_print_jobs.ps1

Enjoy ”

I thought there might be somebody out there that might want this. Its a alarm clock script that quarries a weather server then reads it alloud. Then launches Pandora. Pandora is launched in the system default browser so if your like me with several security extension you might need to whitelist Pandora so it will just play unattended. The cmdlet that reads outload is an add-on module to the Powershell library so you will need that if you want it read. Otherwise you could always flip it around and just have it displayed on your screen. Of coarse a RSS reader could easily do that. Have fun!! I did.
<p style=”text-align: left;”><strong><span style=”color: #339966;”><em>#alarm function
$date = get-date
$hour = $date.hour
$wakeup = 6
#wakeup variable is based on 24hr clock
while ($hour -ne $wakeup)
{
$date = get-date
start-sleep -s 300
#I have the start-sleep command
#to cut down on CPU cycles
#its setup to check the time every 5min
$hour = $date.hour
}
out-speech “Looking up Weather, Sir”
#begining of weather call
Import-Module Pscx
$weather = New-WebServiceProxy -uri http://www.webservicex.com/globalweather.asmx?WSDL
([xml]$weather.GetWeather(‘Washington DC’,'United States’)).CurrentWeather
([xml]$weather.GetWeather(‘Washington DC’,'United States’)).CurrentWeather | out-speech
# Pandora launch
explorer http://pandora.com
# close window scrip on key press
Write-Host “Press any key to continue …”
$x = $host.UI.RawUI.ReadKey(“NoEcho,IncludeKeyDown”)
out-speech “Closing Window, Sir” </em></span></strong></p>