Powershell - concatenating an array reference with another variable

Question

I'm trying to concatenate a variable with a value from an array, and having problems.

The output I get is the variable value, plus the ENTIRE array, not just the desired value (index of $i).

$Database = "Checklist.dbo."

$ExtractTables = @("Page"
    , "HotelOwner"
    , "Hotel"
)

for ($i=0; $i -le $ExtractTables.Length – 1; $i++)  {

    write-host $Database$ExtractTables[$i]     # <<<<<<< takes ENTIRE array
}

My ultimate goal is to call an executable (bcp) something like this:

# & bcp $Database$ExtractTables[$i] out $OutputDirectory$ExtractTables[$i].txt -c -T -SCHELDEV02

Any pointers for a newbie?

Thanks!

jon Z · Accepted Answer · 2012-01-16 14:48:41Z

1

$Database = "Checklist.dbo."

$ExtractTables = @("Page"
    , "HotelOwner"
    , "Hotel"
)

for ($i=0; $i -le $ExtractTables.Length – 1; $i++)  {
    write-host "$Database$($ExtractTables[$i])"
}

To evaluate a sub-expression before the rest of the expression put it inside $()

answered Jan 16, 2012 at 14:48

jon Z

16.7k1 gold badge37 silver badges35 bronze badges

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

Comments

Bill Barry · Accepted Answer · 2012-01-16 14:50:02Z

0

$Database = "Checklist.dbo."

$ExtractTables = @("Page"
    , "HotelOwner"
    , "Hotel"
) 

$ExtractTables | ForEach {
    write-host "$Database$_"
}

answered Jan 16, 2012 at 14:50

Bill Barry

3,5832 gold badges27 silver badges23 bronze badges

Collectives™ on Stack Overflow

Powershell - concatenating an array reference with another variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related