Powershell - How to Transpose an array

Question

I have an array with data separated by a comma. I need to transpose it so the first part before the comma for each line is joined together by a delimiter as one line and the same for a second part. Example:

AC-2.22,CCI-000012
AC-5.1,CCI-000036
AC-5.3,CCI-001380

I want to have 2 separate variables like so:

variable 1 = AC-2.22; AC-5.1; AC-5.3
Variable 2 = CCI-000012; CCI-000036; CCI-001380

I know this should be simple but I've been staring at code all day and I just want to go eat dinner and goto sleep.

Thanks in advance

iRon · Accepted Answer · 2022-12-01 07:49:59Z

3

Based on the $array of the helpful answer from Santiago Squarzon, you might also use the ConvertFrom-Csv cmdlet to transpose the data using member-access enumeration:

$data = ConvertFrom-Csv $Array -Header var1, var2
$data.var1 -Join ';'
AC-2.22;AC-5.1;AC-5.3
$data.var2 -Join ';'
CCI-000012;CCI-000036;CCI-001380

answered Dec 1, 2022 at 7:49

iRon

24.4k10 gold badges60 silver badges107 bronze badges

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

Comments

Santiago Squarzon · Accepted Answer · 2022-12-01 04:14:08Z

This is not too hard using .Where method with Split mode:

$array = @(
    'AC-2.22,CCI-000012'
    'AC-5.1,CCI-000036'
    'AC-5.3,CCI-001380'
)

$i = $false
$var1, $var2 = $array.Split(',').Where({ ($i = -not $i) }, 'Split')
$var1 -join '; '
$var2 -join '; '

.Split method works in this case thanks to Member-Access Enumeration, because arrays don't have an .Split method the same is called over each element of the array:

When you use the member-access operator on any object and the specified member exists on that object, the member is invoked. For property members, the operator returns the value of that property. For method members, the operator calls that method on the object.

When you use the member-access operator on a list collection object that doesn't have the specified member, PowerShell automatically enumerates the items in that collection and uses the member-access operator on each enumerated item.

Collectives™ on Stack Overflow

Powershell - How to Transpose an array

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