René's URL Explorer Experiment

Title: Add `-NoHeader` parameter to `ConvertTo-Csv` and `Export-Csv` cmdlets by ArmaanMcleod · Pull Request #19108 · PowerShell/PowerShell · GitHub

Open Graph Title: Add `-NoHeader` parameter to `ConvertTo-Csv` and `Export-Csv` cmdlets by ArmaanMcleod · Pull Request #19108 · PowerShell/PowerShell

X Title: Add `-NoHeader` parameter to `ConvertTo-Csv` and `Export-Csv` cmdlets by ArmaanMcleod · Pull Request #19108 · PowerShell/PowerShell

Description: PR Summary Fixes #17527 Added -NoHeader to ConvertTo-Csv and Export-Csv cmdlets. PR Context Currently we have no easy way to export a CSV file without headers, but we have the ability to import CSV files with headers using Import-Csv -Header. This change allows ConvertTo-Csv and Export-Csv to export without headers. This simplifies scenarios where the user may not care about headers and removes need to manipulate the CSV to achieve a header less CSV. So instead of always having to skip the first row when writing to CSV: PS C:\> $myObjects = @( > [PSCustomObject]@{ > Name = 'John' > LastName = 'Smith' > } > [PSCustomObject]@{ > Name = 'Freddy' > LastName = 'Kruger' > } > ) PS C:\> $myObjects | ConvertTo-Csv | Select-Object -Skip 1 | Out-File -FilePath 'output.csv' PS C:\> cat 'output.csv' "John","Smith" "Freddy","Kruger" You can now convert to CSV without headers using ConvertTo-Csv -NoHeader: PS C:\> $myObjects | ConvertTo-Csv -NoHeader | Out-File -FilePath 'output.csv' PS C:\> cat 'output.csv' "John","Smith" "Freddy","Kruger" You can also choose to export without headers using Export-Csv -NoHeader: PS C:\> $myObjects | Export-Csv -Path 'output.csv' -NoHeader PS C:\> cat 'output.csv' "John","Smith" "Freddy","Kruger" Or import first, manipulate pipeline object to something else, then export again with no headers: PS C:\> (Import-Csv -Path 'output.csv' | Select-Object -Property Name) | Export-Csv -Path 'output.csv' -NoHeader PS C:\> cat 'output.csv' "John" "Freddy" PR Checklist PR has a meaningful title Use the present tense and imperative mood when describing your changes Summarized changes Make sure all .h, .cpp, .cs, .ps1 and .psm1 files have the correct copyright header This PR is ready to merge and is not Work in Progress. If the PR is work in progress, please add the prefix WIP: or [ WIP ] to the beginning of the title (the WIP bot will keep its status check at Pending while the prefix is present) and remove the prefix when the PR is ready. Breaking changes None OR Experimental feature(s) needed Experimental feature name(s): User-facing changes Not Applicable OR Documentation needed Issue filed: MicrosoftDocs/PowerShell-Docs#9809 Testing - New and feature N/A or can only be tested interactively OR Make sure you've added a new test if existing tests do not effectively test the code changed Tooling I have considered the user experience from a tooling perspective and don't believe tooling will be impacted. OR I have considered the user experience from a tooling perspective and opened an issue in the relevant tool repository. This may include: Impact on PowerShell Editor Services which is used in the PowerShell extension for VSCode (which runs in a different PS Host). Issue filed: Impact on Completions (both in the console and in editors) - one of PowerShell's most powerful features. Issue filed: Impact on PSScriptAnalyzer (which provides linting & formatting in the editor extensions). Issue filed: Impact on EditorSyntax (which provides syntax highlighting with in VSCode, GitHub, and many other editors). Issue filed:

Open Graph Description: PR Summary Fixes #17527 Added -NoHeader to ConvertTo-Csv and Export-Csv cmdlets. PR Context Currently we have no easy way to export a CSV file without headers, but we have the ability to import C...

X Description: PR Summary Fixes #17527 Added -NoHeader to ConvertTo-Csv and Export-Csv cmdlets. PR Context Currently we have no easy way to export a CSV file without headers, but we have the ability to import C...

Opengraph URL: https://github.com/PowerShell/PowerShell/pull/19108

X: @github

direct link

Domain: github.com

Links:

Viewport: width=device-width