Brandon Shell

It should work if your header field is filled out.

header1,header2,header3
field1,"field 2,sfd",
field1,field2,field3

9# Import-Csv $pwd\test.csv

header1 header2 header3
------- ------- -------
field1 field 2,sfd
field1 field2 field3

"Frank" <Frank@discussions.microsoft.com> wrote in message
news:BADF24EE-5D76-4152-8FF6-7EFD0F47CA42@microsoft.com...
>I seem to get errors unless all fields are there, for example in my first
> line, I have the right amount of commas but there is no third field:
>
> field1,"field 2,sfd",
> field1,field2,field3
>
> I would get the error:
>
> $test =import-csv test.csv
> Import-Csv : Cannot process argument because the value of argument "name"
> is
> invalid. Change the value of the "name" argument and run the operation
> again.
> At line:1 char:18
> + $test =import-csv <<<< test.csv
>
>
> I have verified that if there was a third field, it would work. Is there
> a
> way around this?
>
> Thanks,
>
>
>
> "Brandon Shell" wrote:
>
>> I would add headers to the CSV
>> Here is my test file
>> ====== TEST FILE =======
>> Header1,Header2,Header3
>> this is field1,"fieldtwo,fieldtwo",this is field 3
>> ====== TEST FILE =======
>>
>> You can then use import-csv to import for parsing
>> PS> $csvimporttest = import-csv test.csv
>> PS> $csvimporttest
>> Header1 Header2
>> Header3
>> ------ ------
>> ------
>> this is field1 fieldtwo,fieldtwo
>> this is field 3
>>
>> As you can see... the quotes worked as expected.
>>
>> Then to parse like this
>> ===== CODE =====
>> $csvimporttest = import-csv test.csv
>> foreach($object in $csvimporttest)
>> {
>> write-host $object.header1
>> write-host $object.header2
>> write-host $object.header3
>> }
>> ===== CODE =====
>>
>> "Frank" <Frank@discussions.microsoft.com> wrote in message
>> news:FED131FD-F83D-4E0B-BE0E-7C314E314855@microsoft.com...
>> > Hi,
>> >
>> > What is the best way to parse a csv comma delimeted file which may have
>> > commas in the fields. If there are commas in the field, it is enclosed
>> > in
>> > double quotes, ie.
>> >
>> > field1,field2,field3
>> > "field1, abc",field2,field3
>> >
>> >
>> > So, in the second row, the first field would be: "field1, abc"
>> >
>> > Thanks in advance,
>> >
>> >
>>
>>