Split a string from a table in a txt

Question

Why doesn't it split/ remove the other two values in front of the searched value?

I only need the value after ttt.

Auto               Fahrrad              Roller                                                                        
------------------ -------------------- --------------------------------------------------------------------------------
HA_123                 			79777   ttt2345                 
HA_123                          79778   ttt4567  

Answer 1

I think I'd do it differently:

$regex = "[^\s]+\s+[^\s]+\s+ttt(\d+)"   # Not Whitspace / Whitespace / Not Whitspace / Whitespace ttt digits

$filePath = "C:\Users\zippi\Desktop\PowershellTest"
$global:Ids = $null

Get-ChildItem $filePath -Filter *.txt -Recurse | 
    ForEach-Object {
        Get-Content $_.FullName |
            ForEach-Object{
                if($_ -match $regex){
                    $Ids += $matches[1]
                }
    }
}