Skip the first line import-csv in Powershell
Is it possible to skip the first line on a csv file when i do import-csv? Like in this photo. My logical header are the 'nom du client, client ipv4,etc.... But the header that powershell show me is the QM4338...
How is it possible to take the second line for my true header ?
Solution
You can read the file contents from disk with Get-Content, then discard the first line and pipe the remaining lines to ConvertFrom-Csv:
$csv = Get-Content $path |Select-Object -Skip 1 |ConvertFrom-Csv -Delimiter ';'
- MariaDB : create database and execute sql script without '<' character from the command line cmd.exe
- run install-package without it prompting to install nuget
- run powershell script from anywhere
- Right click open new powershell file open in PSIDE
- Powershell prompt, red trailing character on error
- I cannot update ini file. Treating ini file as hastable in Powershell
- PSCustomObject to Hashtable
- 'using:' and other methods not working with start-threadJob to load objects into job session
- How do I refocus a Powershell script after a Start-Process?
- How to auto extract cbz in subfolders on windows?
- How to read or get or fetch automatically the setting values from [Control Panel > Security and Maintenance] using Batch Script or PowerShell?
- Open an Excel File, Read Specific Contents, Print the Output
- Using PowerShell to write a file in UTF-8 without the BOM
- How do I fix a Powershell problem with button selection?
- Azure Yaml pipeline cancelTimeoutInMinutes not working
- PowerShell - how to import module in a script without polluting the global scope?
- Powershell Get-Process. works the first time, fails the 2nd time
- Use Invoke-SQLCmd and return number of rows deleted/affected
- UNIX format files with Powershell
- PowerShell Subprocess Launched via debugpy Doesn’t Inherit Environment Variables (but cmd.exe does)
- Force Batch file called with Invoke-Item to use a certain working directory
- Powershell and wmi, how to map logical disk/volumes to a hard disk or vice versa?
- Possible to pull info from AdditionalProperties dictionary with Microsoft Graph PowerShell cmdlets?
- Add-AppxPackage : Deployment failed with HRESULT: 0x80073CF3, Package failed updates, dependency or conflict
- PowerShell | AutoCompleter not working with TAB completion with custom array
- PowerShell compare but exclude .txt files
- Microsoft Graph PowerShell cmdlet not returning @odata.deltaLink or @odata.nextLink in delta query
- After running a custom PowerShell script in Power Automate Desktop, how do I capture the output into a new variable?
- Comparing array variables in PowerShell
- How to edit Excel Online file by Powershell using Microsoft Graph API?