PowerShell 7.3 - implementing Importing CSV Data and Handling Special Characters
I'm working on a personal project and This might be a silly question, but I'm having trouble importing a CSV file in PowerShell 7.3 that contains special characters, particularly commas within quoted fields. When I use `Import-Csv`, it seems to misinterpret the commas as field separators, which leads to incorrect data assignments. For example, given the following CSV content: ```csv Name, Age, Note "John Doe", 30, "Loves, hiking" "Jane Smith", 25, "Enjoys, painting" ``` When I run this command: ```powershell $data = Import-Csv -Path 'C:\path\to\file.csv' ``` The output is: ```powershell Name Age Note ---- --- ---- John Doe 30 Loves Jane Smith 25 Enjoys ``` It seems to be dropping the text after the comma in the `Note` column. I've tried using `-Delimiter ','` explicitly, but that doesn't help. I also attempted to use the `-Encoding` parameter, assuming there might be an encoding scenario, but that didn't resolve the question either. Is there a way to correctly import CSV data with special characters, particularly when they include commas within quotes? Any insights or best practices would be greatly appreciated. Any help would be greatly appreciated! Cheers for any assistance! Has anyone else encountered this?