Cannot process argument because the value of argument “name” is invalid
I was trying to read a CSV file with Powershell, with the command
but I Kept getting the error :
Import-Csv:Cannot process argument because the value of argument"name"isinvalid.
Change the value of the"name"argument andrun the operation again.
I messed around with the “path” of the Import-CSV command but I just couldn’t make it work. Apparently this has nothing to do with the path of the CSV file. The Warlock posted this on his blog:
Long story short, the error came from having trailing blank columns in my CSV. Import-Csv uses the first row in the CSV as names for the columns (unless you specify otherwise) and when you have blank columns (or at least multiple blank columns) it causes this error as it doesn’t have a valid name for them
Instead of changing the file, I changed my import command to include the headers as per Dales Comment and it worked perfect: