PowerShell File

Using ConvertFrom-Json Cmdlet We can use the ConvertFrom-Json cmdlet to traverse the JSON file with first and nested-level keys; Let’s explore them below. Traverse JSON File Containing First-Level Keys Use ConvertFrom-Json with the foreach loop to traverse the JSON file having first-level keys only. { "name": "John Christoper", "age": 40, "city": "Washington" } $jsonData = […]

Using Get-ChildItem Cmdlet Use the Get-ChildItem cmdlet with -Path and -Filter parameters to find the specified files and directories in the given path in PowerShell. Get-ChildItem -Path "E:\Test" -Filter "file*" Directory: E:\Test Mode LastWriteTime Length Name ---- ------------- ------ ---- d----- 4/25/2023 7:22 AM File -a---- 3/10/2023 12:42 AM 33629 file - Copy.doc -a---- 3/11/2023 […]

For this article, our working directory will be C:\Test1 containing two files named File1.txt and File2.txt. Using Get-ChildItem along with Sort-Object Cmdlet Use the Get-ChildItem cmdlet with Sort-Object` cmdlet to get last modified file in directory in PowerShell. Sort-Object cmdlet will sort the File object by LastWriteTime property. Get-ChildItem -Path C:\Test1 | Sort-Object LastWriteTime -Descending […]

All the code snippets are written in the MyScript.ps1 file; you can name this file to any name of your choice. Using Automatic Variable $args Use automatic variable $args to pass multiple parameters to PowerShell script. foreach ($arg in $args) { Write-Host "Argument: $arg" } .\MyScript.ps1 "Param1" "Param2" "Param3" Argument: Param1 Argument: Param2 Argument: Param3 […]

Using LastWriteTime property To compare LastWriteTime of two files in PowerShell: Use Get-Item to get items. Use the if-else block to compare LastWriteTime of both files. $fileName1 = Get-Item "E:\Test\file1.txt" $fileName2 = Get-Item "E:\Test\file2.txt" if ($fileName1.LastWriteTime -eq $fileName2.LastWriteTime) { Write-Host "The LastWriteTime of the '$($fileName1.Name)' and '$($fileName2.Name)' is same." } elseif ($fileName1.LastWriteTime -gt $fileName2.LastWriteTime) { […]

Appending Text to a Text File We have various approaches to append content in a text file using PowerShell. For example, we can append information on the same line, on a new line with/without special characters, on multiple lines, and append formatted data such as tabular content. But, before moving towards possible solutions, it is […]

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 […]

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, […]