Forum Discussion
Importing CSV, splitting names and joining
Hi, Very new to PowerShell and scripting so I'm trying to do a lab exercise. I'm trying to take input from a CSV file where the name is formatted as "Surname, Name". When I split this it returns...
Here is a possible solutions
$Users = Import-Csv -Path "C:\Users\user\Scripts\Labs\StuffForLabs\UserListB.csv" -Delimiter ";" | ForEach-Object { ($_.Name -split ', ') } for ($i=0; $i -le ($users.count-1); $i=$i+2 ){ $Users[$i+1] + " " + $Users[$i] }this is the output
Dorthy Rhodes Chauncey Woodward Julian Horn
Sorry I forgot to add $
$Users = Import-Csv -Path "C:\Users\user\Scripts\Labs\StuffForLabs\UserListB.csv" -Delimiter ";" |
ForEach-Object {
($_.Name -split ', ')
}
$i=1
$j=0
ForEach ($user in $users) {
$name = @($Users[$i] + " " + $Users[$j])
$i=$i+2
$j=$j+2
$name
}
$Users = Import-Csv -Path "C:\Users\user\Scripts\Labs\StuffForLabs\UserListB.csv" -Delimiter ";" |
ForEach-Object {
($_.Name -split ', ')
}
$i=1
$j=0
ForEach ($user in $users) {
$name = @($Users[$i] + " " + $Users[$j])
$i=$i+2
$j=$j+2
$name
}
Uh, I should have seen that myself so that's on me! Just tired after steering at the same lines and comparing it to "google" for hours.
Grateful for you help, and this makes more sense to n00b !
