import-csv with multiple elements on the same line

Question

Hi,

Let's say i have a csv file like this:

IP

1. 1.1.1
2. 2.2.2

Then if I do:

import-csv $InputCSVFile -delimiter ',' -Encoding UTF8 | ForEach-Object {

try {
$IP = $_.IP
do something
}

Then everything works fine and the current IP address gets assigned to $_ and all is good.

But now, if my file looks like this instead:

IP

1. 1.1.1,2.2.2.2

Then it only takes the first IP into account. In reality the file contains many IPs on the same line. Then I do not want to have a giant header like IP1,IP2,IP3,IP100.
So I tried to use the split function with the get-content function but then each ip is not treated as an object.

How should I do that?

Thanks
Vince

Answer 1

Use a different delimiter in the Import-Csv, a delimiter that doesn't exist in the csv file. Maybe something like this:

import-csv $InputCSVFile -delimiter ';' -Encoding UTF8 |   
    ForEach-Object {  
        $_.IP -split ',' |  
            ForEach-Object{  
                Try{  
                    # do somthing with $_  
                }  
                Catch{  
                    # doing something failed  
                }  
            }  
    }  

Answer 2

Hi @Vinny Vinchenzo ,

You can try this in your Csv file if you have a , in a column:

"IP"  
"1.1.1.1,2.2.2.2"  

This way you should be able to use split.

$IP = "1.1.1.1,2.2.2.2"  
$IP.Split(",")  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten