Converting array variable in powershell to a comma delimited list

Question

I have a powershell code which retrieves some data from the database, the declared data type is an array.

    @my_data = @()
    
    $x = (invoke-sqlcmd -serverinstance x -database y -Query "select name from first_table")
    $y = (invoke-sqlcmd -serverinstance xx -database yy -Query "select name from second_table")
    $my_data = $x + $y
    $my_data = $my_data | select -unique
    $my_data = "Tom Tim Jo"
    $required_format = "Tom,Tim,Jo"

In the example above, I require the format to be comma delimited, at the moment its space delimited.

The issue is that a function that I am passing $my_data to requires it to be comma delimited.

I have tried to use -join ',' as suggested on other SO pages and examples to no avail, as the variable isn't getting comma delimited.

Dennis · Accepted Answer · 2022-11-01 17:34:26Z

2

The .Net method Replace() will work

$my_data.Replace(' ',',')

answered Nov 1, 2022 at 17:34

Dennis

2,1282 gold badges20 silver badges46 bronze badges

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

Comments

frankM_DN · Accepted Answer · 2022-11-01 17:12:02Z

1

Try splitting $my_data first.

$required_format = my_data -split " " -join ","

answered Nov 1, 2022 at 17:12

frankM_DN

3811 silver badge7 bronze badges

Collectives™ on Stack Overflow

Converting array variable in powershell to a comma delimited list

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