Learn about Windows PowerShell
Summary: Use a custom delimiter with Windows PowerShell when reading a CSV file.
Can I use a delimiter other than the comma ( , ) when reading from a CSV file?
Import-CSV has a parameter dedicated for this purpose called -Delimiter:
Get-Help Import-Csv -ShowWindow
You can easily use this during the import:
Users who work with multiple languages and/or have configured different region/language should consider using the following to determine the system delimiter:
Thanks / rgds,