Best way to extract CSV data from a file in to an array

[madg...@gmail.com]

Hi Guys,

I have a CSV file exported from an LDAP query which I need to build an array from.
At the moment I have some fields containing commas surrounded by quotes.

"cn=JOHNSMITH,ou=SALES,o=COMPANY",JOHN,JOHN SMITH,,SMITH,,,"1 West Street, Westland",,,42,,,JOHN SMITH,,,,,,,,

What is the most elegant way to get an array with the items within the quotes intact.
as per below...

cn=JOHNSMITH,ou=SALES,o=COMPANY
JOHN
JOHN SMITH
:
SMITH
:
1 West Street, Westland
:
42
:
JOHNSMITH
:
:

I would prefer not to have to do it char by char as the export is rather large.

Thanks

G

[Gloops]

Hello,

Char by char ?
I should be curious to know where you got your documentation of Powershell.
Try something like that :

get-content info.csv | convertfrom-csv

--