Styjun

Who voices the character "Finger" in The Fifth Element?

I need help with pasta

Warnings of R. Chaim Vital

Can a nowhere continuous function have a connected graph?

What verb for taking advantage fits in "I don't want to ________ on the friendship"?

How can a valley surrounded by mountains be fertile and rainy?

Can European countries bypass the EU and make their own individual trade deal with the U.S.?

Does a return economy-class seat between London and San Francisco release 5.28 tonnes of CO2 equivalents?

Put my student loan in parents’ second mortgage - help?

Reusable spacecraft: why still have fairings detach, instead of open/close?

"Vector quantity" --More than two dimensions?

Is Cyclic Ether oxidised by periodic acid

Converting Geographic Coordinates into Lambert2008 coordinates

Do home values typically rise and fall at a consistent percent?

How can I tell what kind of genitals people have without gender?

How to securely dispose of a smartphone?

Do the 26 richest billionaires own as much wealth as the poorest 3.8 billion people?

Is it okay to fade a human face just to create some space to place important content over it?

Movie with Zoltar in a trailer park named Paradise and a boy playing a video game then being recruited by aliens to fight in space

What kind of jet plane is this?

How to plan the font size in a fiction?

Sacrifice blocking creature before damage is dealt no longer working (MtG Arena)?

Can you actually break an FPGA by programming it wrong?

Can a stressful Wish's Strength reduction be cured early by a Greater Restoration spell?

Read multiple values from a column in a csv file and pass to a function

How do I pass multiple parameters into a function in PowerShell?In PowerShell, how do I define a function in a file and call it from the PowerShell commandline?Function return value in PowerShellPowershell incrementing name and execute cmdlineFunction calling itself to enumerate nested group membershipsAdding unrelated column to export-csv -appendArranging output to CSV from Powershell foreach loopRemove a different list of AD groups from a long list of usersPowershell - Querying CSV column names and writing them to a new CSV

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have a file named group.csv which contains data like the below:

Name group location
A group1 local
B group1,group2 local2
c group1,group2,group3 local3

I am not able to read group1, group2 or group3 independently and I am therefore unable to pass the values correctly in to a function.

Here is my code:

$fpath = Import-Csv C:klcgroup.csv
foreach($abc in $fpath){
$Name = $abc.Name
$group = $abc.group
$location = $abc.location

 function display ($Name,$group,$location)
 

 $group01 = $group

 for($i=0;$i -lt $group01.count;$i++)
 
 try
 Add-group -Name $Name -Group $group01[i] -Location Location -ErrorAction 
stop
 catch [Expression]
 
 Write-Host "Unable to Add"
 
 Write-Host "successfully Added"
 
 

powershell

share|improve this question

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

add a comment | 

0

I have a file named group.csv which contains data like the below:

Name group location
A group1 local
B group1,group2 local2
c group1,group2,group3 local3

I am not able to read group1, group2 or group3 independently and I am therefore unable to pass the values correctly in to a function.

Here is my code:

$fpath = Import-Csv C:klcgroup.csv
foreach($abc in $fpath){
$Name = $abc.Name
$group = $abc.group
$location = $abc.location

 function display ($Name,$group,$location)
 

 $group01 = $group

 for($i=0;$i -lt $group01.count;$i++)
 
 try
 Add-group -Name $Name -Group $group01[i] -Location Location -ErrorAction 
stop
 catch [Expression]
 
 Write-Host "Unable to Add"
 
 Write-Host "successfully Added"
 
 

powershell

share|improve this question

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

add a comment | 

I have a file named group.csv which contains data like the below:

Name group location
A group1 local
B group1,group2 local2
c group1,group2,group3 local3

I am not able to read group1, group2 or group3 independently and I am therefore unable to pass the values correctly in to a function.

Here is my code:

$fpath = Import-Csv C:klcgroup.csv
foreach($abc in $fpath){
$Name = $abc.Name
$group = $abc.group
$location = $abc.location

 function display ($Name,$group,$location)
 

 $group01 = $group

 for($i=0;$i -lt $group01.count;$i++)
 
 try
 Add-group -Name $Name -Group $group01[i] -Location Location -ErrorAction 
stop
 catch [Expression]
 
 Write-Host "Unable to Add"
 
 Write-Host "successfully Added"
 
 

powershell

share|improve this question

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

Name group location
A group1 local
B group1,group2 local2
c group1,group2,group3 local3

$fpath = Import-Csv C:klcgroup.csv
foreach($abc in $fpath){
$Name = $abc.Name
$group = $abc.group
$location = $abc.location

 function display ($Name,$group,$location)
 

 $group01 = $group

 for($i=0;$i -lt $group01.count;$i++)
 
 try
 Add-group -Name $Name -Group $group01[i] -Location Location -ErrorAction 
stop
 catch [Expression]
 
 Write-Host "Unable to Add"
 
 Write-Host "successfully Added"
 
 

share|improve this question

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

share|improve this question

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

edited Mar 25 at 14:15

Mark Wragg

15.9k55 gold badges2222 silver badges4747 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

asked Mar 25 at 14:06

kranthikranthi

3744 bronze badges

1 Answer
1

active

oldest

votes

0

Two things:

1. You probably want to move the display function above the other code so you can call it.
2. You need to split the group value (read from the csv) to get to the individual values.
The line that says:

$group01 = $group

Could be

$group01 = $group.Split(',')

share|improve this answer

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55339671%2fread-multiple-values-from-a-column-in-a-csv-file-and-pass-to-a-function%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Two things:

1. You probably want to move the display function above the other code so you can call it.
2. You need to split the group value (read from the csv) to get to the individual values.
The line that says:

$group01 = $group

Could be

$group01 = $group.Split(',')

share|improve this answer

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

add a comment | 

0

Two things:

1. You probably want to move the display function above the other code so you can call it.
2. You need to split the group value (read from the csv) to get to the individual values.
The line that says:

$group01 = $group

Could be

$group01 = $group.Split(',')

share|improve this answer

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

add a comment | 

Two things:

1. You probably want to move the display function above the other code so you can call it.
2. You need to split the group value (read from the csv) to get to the individual values.
The line that says:

$group01 = $group

Could be

$group01 = $group.Split(',')

share|improve this answer

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

$group01 = $group

$group01 = $group.Split(',')

share|improve this answer

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges

answered Mar 25 at 14:25

Mike ShepardMike Shepard

13.3k66 gold badges4141 silver badges5757 bronze badges