Creating an array from values in a text file with powershell

Question

I have a text file with this content:

SEGMENTS="worker01 worker02 worker03 worker04"
WORKER_SEGMENTS="worker01 worker02 worker03 worker04"
#SEGMENTS="worker01"
#WORKER_SEGMENTS="worker01"

I read this file from another powershell script and I want to to create an array of the WORKER_SEGMENTS values. I have gotten so far:

$workers = Get-Content $strPath"\worker\conf\segments.conf" | Where-Object {$_ -like "*WORKER_SEGMENTS*"}
Write-Host $workers

This yields:

PS Q:\mles\etl-i_test\rc> .\etl.ps1
WORKER_SEGMENTS="worker01 worker02 worker03 worker04" #WORKER_SEGMENTS="worker01"

I only need the worker01, worker02, worker03, worker04 from WORKER_SEGMENTS (without the leading #) as an array. How do I achieve this?

Frode F. · Accepted Answer · 2013-05-03 15:49:04Z

3

You can try this:

Get-Content .\t.txt | 
? { $_ -like "WORKER_SEGMENTS*" } | 
% { $_ -replace '.*?"([^"]*)".*', '$1' -split " " }

worker01
worker02
worker03
worker04

Or

Get-Content .\t.txt | 
? { $_ -like "WORKER_SEGMENTS*" } | 
% { ($_ -split '"')[1] -split ' ' }

worker01
worker02
worker03
worker04

answered May 3, 2013 at 15:49

Frode F.

55.4k9 gold badges104 silver badges118 bronze badges

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

2 Comments

mles Over a year ago

This seems to be the answer I can understand the most. What does % { ($_ -split '"')[1] -split ' ' } do?

Frode F. Over a year ago

It gets content between the first two " (which is the workernames), then it turns the names into an array by splitting on space. The first sample does the same using regex.

Keith Hill · Accepted Answer · 2013-05-03 15:51:08Z

2

Try this:

Get-Content $strPath"\worker\conf\segments.conf" | 
    Select-String 'WORKER_SEGMENTS\s*=\s*"([^"]*)"' | 
    Foreach {$_.Matches.Groups[1].Value -split ' '} | 
    Foreach {$ht=@{}}{$ht.$_=$null}
$ht

By using a hashtable we can eliminate duplicate entries fairly easily.

answered May 3, 2013 at 15:51

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

Comments

EBGreen · Accepted Answer · 2013-05-03 15:46:43Z

1

you may have to tweak it a bit to get exactly what you want, but this should get you headed in the right direction:

$workers = (Get-Content $strPath"\worker\conf\segments.conf" | ?{$_ -like 'Worker_Segments*'}).Split('"')[1].Split(' ')

answered May 3, 2013 at 15:46

EBGreen

38k12 gold badges69 silver badges86 bronze badges

Collectives™ on Stack Overflow

Creating an array from values in a text file with powershell

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related