How to extract in csv multiple value

marie-laurechaume · 2018-09-07T08:45:25.000Z

Hello,

I would like to extract in my csv multiple value when i I import csv :

example :

array contain :

#header name is “Member” in csv contains:

1- import-csv

2- get header and all value:

$member = $group.‘Member’

3- Extract value:

$member = “lastname1 firstname1, lastname2 firstname2 , lastname3 firstname3 ,”

If I split , i would like to get value with escape …

$Members = $member -split “,”

result: $Members:

lastname1 firstname1
lastname2 firstname2
lastname3 firstname3

Constraint: some names contain multiple values (ex: Jean du Jardin)

And I would like to extract one by one.

how can I do this? someone help me?

My code:

ForEach ($user in $Members)

$NameUser=(Get-ADUser -filter “displayname -eq $user”)

Add-ADGroupMember -Identity $groupName -Members $NameUser

Thanks in advance

johnharris3 · 2018-09-07T09:21:36.000Z

Hi,

Are you trying to import users from a CSV File and then do a foreach to add multiple group members to a single group.

as i’m a bit confused as to what you are asking.

reagrds

marie-laurechaume · 2018-09-07T09:31:08.000Z

Yes! Sorry i’m french I would like extract value to Members Like this: Lastname1 firstname1 Goal is add members to group In my file csv , I’ve many members in column “members” $member = “lastname1 firstname1, lastname2 firstname2 , lastname3 firstname3 ,”

johnharris3 · 2018-09-07T10:44:47.000Z

Try this,

$Members = Import-Csv “C:\users\bloggsj\desktop\XXXX.csv” #Enter The location of CSV File see example

$groupName = “Group for new Members” #Group where members will be added

ForEach ($Member in $Members)

{

$NameUser = Get-ADUser -Filter * -Properties * | Where-Object {$_.DisplayName -like $member.Members}

Add-ADGroupMember -Identity $groupName -Members $NameUser.SamAccountName

}

Neally · 2018-09-07T13:16:28.000Z

All, If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2018-09-07T13:21:40.000Z

You’d import the CSV like so.

# import csv
$csv = import-csv "c:\file.csv"
# groupname
$groupname = 'group123'

#put it into a foreach
foreach($line in $csv){
    #find the AD User
    Get-aduser -filter "displayname -like '*$($line.member)*'" |
    # add user to group
    Add-adgroupmember $groupname -verbose
}

jeffreycummings · 2018-09-10T01:35:50.000Z

John, I think your choice of variable names may be confusing to mariech. I had to take a second glance to get things straight, and I’m an intermediate programmer.

Regards,

Jeff