how to handle - import-csv results
Dear experts
I have this command $Items = Import-Csv -path "$CsvFile" -Encoding UTF8 –delimiter ";"
This work pretty well so I can access the collection by having the fieldnames etc.... ($Items.<fieldname> is OK)
BUT how to have a global view ? How to know for $Items, the number of elements?
Tks.
I have this command $Items = Import-Csv -path "$CsvFile" -Encoding UTF8 –delimiter ";"
This work pretty well so I can access the collection by having the fieldnames etc.... ($Items.<fieldname> is OK)
BUT how to have a global view ? How to know for $Items, the number of elements?
Tks.
ASKER
$items.count return nothing.
write-host $items
@{IDENTIFIANT=900000003; TITLE_CODE=; TITLE_NAME=; CONTRAT_NB=900000003; NAME=AO; FIRSTNAME=Stagiaire; SEXE=; NATIONAL_ID=; STREET=; STREET_NR=; STREET_BOX=; CITYCODE=; CITY NAME=; COUNTRY NAME=; PHONE_PROF=; GSM_PROF=; EMAIL_PROF=stAO@daoust.be;
write-host $items.count
return nothing
write-host $items
@{IDENTIFIANT=900000003; TITLE_CODE=; TITLE_NAME=; CONTRAT_NB=900000003; NAME=AO; FIRSTNAME=Stagiaire; SEXE=; NATIONAL_ID=; STREET=; STREET_NR=; STREET_BOX=; CITYCODE=; CITY NAME=; COUNTRY NAME=; PHONE_PROF=; GSM_PROF=; EMAIL_PROF=stAO@daoust.be;
write-host $items.count
return nothing
And of course you can just dump everything with $items | format-table -auto or $items | format-list, to see what is in the collection.
That is a single object, no collection. @($Items).Count works though. It forces the content to be an array, and that array always has a Count member.
ASKER
yes indeed Qlemo, but I want to have the number of items on this collection/hashtable what is this object.
ASKER
@($Items).Count report 1 not the count of all elements....
That is a different beast. You want to know the number of (custom) properties of that custom object ...
A hashtable would allow for counting, e.g. @{a=1;b=2}.Count.
A hashtable would allow for counting, e.g. @{a=1;b=2}.Count.
ASKER
Ok. I'm still lost....
how may I know the number of custom properties that has a custom object? (from the import-csv cmdlet) Purpose is dataquality check (see if I have the number of col that I expect)
how may I know the number of custom properties that has a custom object? (from the import-csv cmdlet) Purpose is dataquality check (see if I have the number of col that I expect)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your'e brillant !
Open in new window