PowerShell

Using -Contains Operator Use the -Contains operator to check if the list contains the specified string in PowerShell. $list = @("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday") $searchString = "Wednesday" $list -Contains $searchString True In the above example, we used an array operator represented with @() to create a list, which we stored in the […]

Using Split() Method Use the Split() method with the indexing operator to split the specified string and get the last value in PowerShell. $string = "This is a sample string" $lastElement = ($string.Split(" "))[-1] Write-Host "The last element of '$string' is '$lastElement'" The last element of 'This is a sample string' is 'string' First, we […]

The xlsx file can be easily converted into csv using the following methods: Before converting a file, please ensure that your PowerShell is opened in the administrative mode, and the execution policy should not be set to Restricted. Get-ExecutionPolicy Set-ExecutionPolicy Restricted In the above code, we used the Get-ExecutionPolicy command to check if the execution […]

The csv file can be easily converted into xlsx using the following methods: [toc] Before converting files, please verify that your PowerShell is opened in administrative mode and that the execution policy is not set to Restricted. Get-ExecutionPolicy Set-ExecutionPolicy Restricted The above output demonstrates that the execution policy is set to Restricted. So, if the […]

Using Invoke-Expression Cmdlet Use the Invoke-Expression cmdlet to run a string as a command in PowerShell. Invoke-Expression cmdlet evaluates string as command and return the result of string expression. Here is simple exampple: $command = "notepad.exe" Invoke-Expression $command This will open new notepad window. Here is more complicated example. $command = "Get-Process | Sort-Object -Property […]

In PowerShell 3.0 and higher, we have Invoke-WebRequest and Invoke-RestMethod cmdlets; curl is an alias of the Invoke-WebRequest in PowerShell. Most learners make it confused with the Invoke-RestMethod cmdlet. In PowerShell 7 and higher, the Invoke-RestMethod cmdlet is the default cmdlet for sending RESTful web service requests. It is another built-in cmdlet in PowerShell mainly […]

Using StartsWith() Method Use the StartsWith() to check if string starts with another string in PowerShell. $text = "Hello, world!" $prefix = "Hello" $startsWithPrefix = $text.StartsWith($prefix) Write-Host "Text: $text" Write-Host "Prefix: $prefix" Write-Host "Does '$text' start with '$prefix'? $startsWithPrefix" Text: Hello, world! Prefix: Hello Does 'Hello, world!' start with 'Hello'? True In the above code, […]

Using Get-Module Cmdlet Use Get-Module with -Name parameter to check if a module is installed in PowerShell. Get-Module -ListAvailable -Name ImportExcel Directory: C:\Users\user\Documents\WindowsPowerShell\Modules ModuleType Version Name ExportedCommands ---------- ------- ---- ---------------- Script 7.8.4 ImportExcel {Add-ConditionalFormatting, Add-ExcelChart, Add-ExcelDataV... The Get-Module retrieves information about loaded modules and available modules that can be imported. The -ListAvailable parameter filters […]

For this article, we are using three directories, E:\Test\Script Files, E:\Test\Test Files, and E:\Test\Sample Files. The E:\Test\Script Files directory is not empty and contains test.bat and testPS.ps1 files, while the E:\Test\Test Files directory is empty because it contains nothing, neither files nor folders The E:\Test\Sample Files directory is also not empty; it contains file.txt, file1.txt, […]