Frank

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,
> >
> >
>
>