Skip to content

Double quote delimiter in Import-Csv #7110

@iSazonov

Description

@iSazonov

Why double quote delimiter has a special behavior (skipping columns) in Import-Csv?
Is this expected/documented/RFC-defined behavior?

# Input 1.csv
# a1""a3
# v1"v2"v3

Import-csv .\1.csv -Delimiter '"'

# Output
a1 a3
-- --
v1 v3
# Input 2.csv
# a1,,a3
# v1,v2,v3

Import-csv .\2.csv -Delimiter ','

# Output
WARNING: One or more headers were not specified. Default names starting with "H" have been used in place of any missing headers.

a1 H1 a3
-- -- --
v1 v2 v3

Metadata

Metadata

Assignees

No one assigned

    Labels

    HacktoberfestPotential candidate to participate in HacktoberfestIssue-Questionideally support can be provided via other mechanisms, but sometimes folks do open an issue to get aResolution-FixedThe issue is fixed.Up-for-GrabsUp-for-grabs issues are not high priorities, and may be opportunities for external contributorsWG-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