Specifies the character that the provider uses to replace file path separators when generating table names.

Syntax

Connect-CSV -PathSeparator string

Data Type

cstr

Default Value

"_"

Remarks

When this property is set, the cmdlet replaces any directory separators in file paths with the specified character when naming tables.

For example, if a file is located at Test/CSVFiles/Test.csv and this property is set to _, the resulting table name is Test_CSVFiles_Test.csv.

This property is useful for creating valid table names when working with files organized in nested folders.