Skip to content

Automatic delimiter option for Import-Csv and ConvertFrom-Csv #26848

@iRon7

Description

@iRon7

Summary of the new feature / enhancement

Use case:
The supplier(s) of the csv files I need to process aren't very keen on which delimiters they use.
In most cases the delimiter of an csv file could be determined from the header and/or the first few records (especially if fields are quoted)

Proposed technical implementation details (optional)

Support an -Delimiter Auto value for Import-Csv and ConvertFrom-Csv
If the delimiter can't be determined, default to a comma (,), or if the delimiter can't be determined with certainty, return a (non-terminating) error or warning.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Issue-Enhancementthe issue is more of a feature request than a bugNeeds-TriageThe issue is new and needs to be triaged by a work group.WG-Cmdlets-Utilitycmdlets in the Microsoft.PowerShell.Utility module

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions