What's the powershell syntax for multiple values in a switch statement and set result to variable?

Question

i have a requirement in powershell if filename contains abc then set $tablename to abc_stg if filename contains pqr set $tablename to pqr_stg. Can anyone help.

switch ($file_name) {
    abc {"dbo.abc_stg"}
    pqr {"dbo.pqr_stg"}

}

Andrew Shepherd · Accepted Answer · 2017-08-24 01:59:31Z

1

See this page: Using Wildcards with the Switch Statement

In your case:

$tablename = switch -wildcard ($file_name)
    {
        "*abc*" { "dbo.abc_stg" }
        "*pqr*" { "dbo.pqr_stg" }
        default { "No match" }
    }

answered Aug 24, 2017 at 1:59

Andrew Shepherd

45.5k33 gold badges148 silver badges212 bronze badges

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

Collectives™ on Stack Overflow

What's the powershell syntax for multiple values in a switch statement and set result to variable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related