Cmdlets for CSV

Build 24.0.9060

TypeDetectionScheme Parameter (Connect-CSV Cmdlet)

Determines how to determine the data types of columns.

Syntax

Connect-CSV -TypeDetectionScheme string

Possible Values

None, RowScan, ColumnCount

Data Type

cstr

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None will return all columns as the string type.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.
ColumnCountSetting TypeDetectionScheme to ColumnCount will control the number of columns to detect and will return all columns as the string type. The ColumnCount property determines the number of columns.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060