Powershell String

[mattbrice30 Participant Topics: 1 Replies: 1 Points: 13Rank: Member]

I’m new to powershell, so bear with me.  I’m trying to do something I thought would be easy and common: find file paths that are “too long” (greater than some value. i.e. 260 character).   The below code runs fine, but while I can either output the file paths or and I can pipe to Select-Object and get the string length, I can’t figure out how to have them both. Get-Member shows $longpathfiles as  a ‘System.String’ type, with the only property being ‘Length’. What I want to end up with is a 2 column table.  ‘PathLength’, and ‘Path’ I can pipe to Out-Gridview or csv.  So….what am I missing?  Thanks in advance.

PowerShell

$longpathfiles = robocopy . NULL /L /s /njh /njs /fp /ns /nc /ndl | where length -gt 260 | foreach { $_.trim() }

1	$longpathfiles =  robocopy . NULL /L /s /njh /njs /fp /ns /nc /ndl | where length -gt 260 | foreach { $_.trim()  }

 

[kvprasoon Senior Moderator Topics: 9 Replies: 1445 Points: 5,410Rank: Community MVP]

Almost there… You just need to create a PSCustomObject foreach paths with the path name and length

PowerShell

$longpathfiles = robocopy . NULL /L /s /njh /njs /fp /ns /nc /ndl | Where-Object length -gt 260 | ForEach-Object -Process { if ($Null -ne $_.trim()) { [PSCustomObject]@{ Path = $_.trim() Length = $_.Trim().Length } } }

1 2 3 4 5 6 7 8

$longpathfiles = robocopy . NULL /L /s /njh /njs /fp /ns /nc /ndl | Where-Object length -gt 260 | ForEach-Object -Process {     if ($Null -ne $_.trim()) {         [PSCustomObject]@{             Path = $_.trim()             Length = $_.Trim().Length         }     } }

[mattbrice30 Participant Topics: 1 Replies: 1 Points: 13Rank: Member]

Thanks for the quick reply. This works great.

 

But question though, why test against $NULL if I’m already filtering out anything with less than 260 character?

[AdminOfThings45 Participant Topics: 1 Replies: 95 Points: 435Rank: Contributor]

You could have lines with 261 white spaces. if ($_.Trim()) should suffice though.

[Author]

Posts