Cmdlets for CSV

Build 25.0.9539

TrimQuotedValues Parameter (Connect-CSV Cmdlet)

Specifies whether the provider trims spaces inside quoted values when applying the TrimSpaces property.

Syntax

Connect-CSV -TrimQuotedValues SwitchParameter

Data Type

bool

Default Value

false

Remarks

When this property is set to true, the cmdlet trims leading and trailing spaces in both quoted and unquoted cell values. When set to false, only unquoted cell values are affected by the TrimSpaces property.

This property is useful for ensuring consistent whitespace handling in files that include quoted values.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539