Passing Array of strings to PowerShell function

Question

I have a function called BuildQuery that takes a Array of values as Parameters.

Function BuildQuery {
Param($start, [String[]] $KeyFields, [String] $Sch, [String] $TableName)
$Query = "select $KeyFields from '$Sch'.'$TableName'"
}

I want to call the function as :

BuildQuery -start start -KeyFields name, id, age, salary -Sch dbo -TableName Employee

E.g. : I want to build a query "select name, id, age, salary from dbo.Employee " using the PowerShell function. The only reason I am using function is I want to see it again and again to build queries like this.

Mathias R. Jessen · Accepted Answer · 2016-10-10 17:55:10Z

6

Use the -join operator to expand the array as a comma-separated list:

Function BuildQuery {
    Param($start, [String[]] $KeyFields, [String] $Sch, [String] $TableName)
    $Query = "select $($KeyFields -join ',') from '$Sch'.'$TableName'"
}

edited Oct 10, 2016 at 17:55

answered Oct 10, 2016 at 17:53

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Martin Brandl Over a year ago

ah, you were just a tick faster :-)

Mathias R. Jessen Over a year ago

@MartinBrandl you've outranked me for almost 2 weeks, great to be back at full speed :-D

HadoopAddict Over a year ago

Awesome! Thats exactly what I wanted! . Can't accept the Answer yet because of some time restriction.. So waiting for it to finish :)

Collectives™ on Stack Overflow

Passing Array of strings to PowerShell function

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related