Import-CSV and Foreach

Question

I ve got a huge comma seperated CSV-list with IP-addresses of my network that I want to run queries against  Example of my CSV input   172 168 0 1 172 168 0 2 172 168 0 3 172 168 0 4   Etc       When I run the following code to test for the output     filepath    c  scripts servers csv    servers   Import-CSV  filepath -delimiter       Foreach   server in  servers         write-host  server      I get no output  I think it s because there are no headers specified  I can obviously do a workaround and open the CSV-file and type in all the headers  Are there any other ways to solve this

User · Accepted Answer

You can create the headers on the fly  no need to specify delimiter when the delimiter is a comma    Import-CSV  filepath -Header IP1 IP2 IP3 IP4   Foreach-Object     Write-Host    IP1    Write-Host    IP2

User · Answer

Solution is to change Delimiter   Content of the csv file  -  Note    Also space and   in value  Values are 6 Dutch word aap noot mies Piet  Gijs  Jan  Col1 Col2 Col3  a ap noo t mi es  P iet G  ijs Ja  n     csv   Import-Csv C  TejaCopy csv -Delimiter        Answer   Write-Host  csv   Col1 a ap  Col2 noo t  Col3 mi es    Col1 P iet  Col2 G  ijs  Col3 Ja  n    It is possible to read a CSV file and use other Delimiter to separate each column   It worked for my script  -

User · Answer

IP Array    Get-Content test2 csv  0  split      foreach    IP in  IP Array        IP     Get-content Filename returns an array of strings for each line    On the first string only  I split it based on       Dumping it into  IP Array    IP Array    Get-Content test2 csv  0  split      foreach    IP in  IP Array     if   IP -eq  2 2 2 2         Write-Host  Found  IP

[powershell] Import-CSV and Foreach

Examples related to powershell

Examples related to csv

Examples related to foreach