PowerTip: Use Custom Delimiter with CSV File
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: