CODEWITHSUNDEEP
regexpowershell
user2591459
user2591459

Reputation: 11

Spiting Regular expression and accessing Array of Array

An example am trying to understand from website. People2.txt is as follows.

2323:Doe John California

827:Doe Jane Texas

982982:Neuman Alfred Nebraska

I don't get the output as shown from the command below.

*PS C:\ Get-Content people2.txt | %{$data = [regex]::split($_, '\t|:'); Write-Output "$($data[2]) $($data[1]), $($data[3])"}

John Doe, California

Jane Doe, Texas

Alfred Neuman, Nebraska*

I could take out numbers and swapping first and second using

gc C:\appl\ppl.txt | %{$data = [regex]::split($_, ":") ;write-output $data[1] } | Out-File c:\appl\ppll.txt

gc C:\appl\ppll.txt | %{$data = $_.split(" "); Write-Output "$($data[1]) $($data[0]), $($data[2])"}

Please help

**Need to find more efficient ways to do this.

Also I want to understand '\t|:' - is it 'Split at first TAB stop and a : ' ?**

Upvotes: 0

Views: 58

Answers (1)

Jake H
Jake H

Reputation: 1740

Just threw this off the top of my head: ^(?<number>\d+):(?<first>\w+)\s+(?<last>\w+)\s(?<location>.*)$

Upvotes: 0

Related Questions