Change Order of CSV Columns

Change Order of CSV Columns

If you have a CSV file and would like to change the order of columns, simply import it into PowerShell, use Select-Object to change the order, and then re-export the CSV file again! $Path = "c:\somepathtocsv.csv" (Import-CSV -Path $Path) | Select-Object -Property...

Change Order of CSV Columns

Check Windows License Status

In a previous tip we explained how you can use slmgr, a built-in VBScript, to check Windows licensing state. Accessing the Raw Licensing Data in PowerShell The core information used by this VBScript actually comes from WMI, so in PowerShell, you can directly access...

Change Order of CSV Columns

Tips for Optimizing XML in SQL Server

I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent, but with some repercussions. As we did our load testing, performance did degrade and we had to step back and adjust how...

Change Order of CSV Columns

Stripping Decimals Without Rounding

Extracting the Integer Part of a Division Result When you divide numbers and just want the decimals before the decimal point, you could cast the result to integer. However, this would also round the result: PS> 18 / 5 3.6 PS> [Int](18/5) 4 Removing Decimals...

Change Order of CSV Columns

Removing Multiple White Spaces

Removing multiple white spaces from text is easy in PowerShell. -replace operator Simply use -replace operator and look for whitespaces ("\s") that occur one or more time ("+"), then replace them all with just one whitespace: PS> '[ Man, it works! ]' -replace...

Change Order of CSV Columns

Sending Emails with Special Characters

Send Emails with PowerShell Using Send-MailMessage PowerShell has built-in support for sending emails: Send-MailMessage! All you need is an SMTP server. However, with standard encoding you may run into issues where special characters are mangled. -Encoding parameter...

Change Order of CSV Columns

Ignoring Empty Lines

Reading Text Files and Skipping Blank Lines To read in a text file and skip blank lines, try this: $file = 'c:\sometextfile.txt' Get-Content $file | Where-Object { $_.Trim() -ne '' } It will omit empty lines, lines with only blanks and lines with only tabs. ReTweet...

Change Order of CSV Columns

Writing Registry Key Default Values

Set the default value for a registry key If you need to set the default value for a registry key, you can use either of these approaches: Set-ItemProperty -Path HKCU:\Software\Somekey -Name ‘(Default)’ -Value MyValue Or, you can just do this: Set-Item -Path...

Change Order of CSV Columns

HTML-Scraping with RegEx

Scraping Website Data with PowerShell To scrape valuable information from websites with PowerShell you can download the HTML code and then use regular expressions to extract what you are after. That's not hard. Here is a sample: $webclient = New-Object...

Change Order of CSV Columns

Case-Sensitive Hash Tables

PowerShell hash tables PowerShell hash tables are, by default, not case sensitive: PS > $hash = @{} PS > $hash.Key = 1 PS > $hash.keY = 2 PS > $hash.KEY 2 Creating Case-Sensitive Hash Tables in PowerShell If you need case-sensitive keys, you can create the...

Change Order of CSV Columns

Making sure PowerShell scripts run in 32-bit

Dealing with 32-bit Dependencies in a 64-bit Environment If you are using code that can only run in a 32-bit environment (i.e. using old database drivers or COM objects), here is a solution that will re-launch the script in a 32-bit PowerShell when it is launched in a...

Change Order of CSV Columns

Configuring WSMan Remotely for multiple computers

When working remotely in a peer-to-peer or cross-domain scenario, you will have to add all the computers you'd like to communicate with into the trusted hosts list. Overwriting Issue When Adding Trusted Hosts Unfortunately, when you try this, any new entry will...

Change Order of CSV Columns

Getting Process Based On Window Title

Identifying a Process by Window Title It isn't always easy to pick the right process because the process ID or process name may not be known or ambiguous. If the process has a window and you can see the window title, all you need to do is search for a keyword in that...

Change Order of CSV Columns

Checking Whether Hash Table Contains Key

Understanding the Limitation of Hash Tables Compared to Switch Statements In the previous tip, you used a hash table to translate input values. However, unlike Switch-statements, Hash Tables have no "default" so all values need to be present in the hash table. Check...

Change Order of CSV Columns

List Hidden Files

Did you notice that Dir, ls or Get-ChildItem do not return hidden files? Use the -Force Parameter to Reveal Hidden Files To see hidden files, you need to specify the -force parameter: Dir $env:windir -force Filter to Show Only Hidden Files But what if you just wanted...