Crthuky

# Microsoft Windows [Version 10.0.17134.648] 
# powershell 5.1.17134.48 
# dir directory. Include index*,avail* where the last write time is less than
# 4 days. Display a parsed Name. Display the Length and the LastWriteTime.

$time = (Get-Date).AddDays(-4)
gci * -include index*,avail* | where $_.LastWriteTime -gt $time | format-table -HideTableHeaders Name,Length,LastWriteTime

outputs:

available13.html.2019-03-26_081523.bak 93130 3/26/2019 8 : 10 : 05 AM
index.html.2019-03-26_081538.bak 93134 3/26/2019 8 : 15 : 23 AM

I would like to parse Name to this:

available13.html 93130 3/26/2019 8 : 10 : 05 AM
index.html 93134 3/26/2019 8 : 15 : 23 AM

If I use:

$delim = "."
gci * -include *index*,*available13* -Name | `
foreach 
 $nameArray = $_.Split($delim)
 $newName = $nameArray[0] + "." + $nameArray[1]
 Write-Output $newName

I get the parsed Name with no date limit, no size and no last write time.

available13.html
available13.html
index.html
index.html

I've tried:

1. gci | gm | oh -paging


2. two days of google search


3. a regex (which I am not proficient at yet)


4. parse gci outfile

It is close. Do I have to take another approach?

I'd use a RegEx with zero length lookbehind assertion to remove everything after html from $_.Name

This can be done with a calculated property either in a Select-Object or also in a Format-*

Get-ChildItem -File | 
 Format-Table @n='foo';e=$_.Name -replace '(?<=^.*.html).*$',Name -HideTableHeaders

Sample output:

available13.html available13.html.2019-03-26_081523.bak
index.html index.html.2019-03-26_081538.bak

You can add a new property with Add-Member like this

$time = (Get-Date).AddDays(-4)
$files = gci * -include index*,avail* | where $_.LastWriteTime -gt $time
foreach ($f in $files) 
 $f 
$files | Format-Table -HideTableHeaders newName,Length,LastWriteTime

Note that the above snippet assumes that your names always end with .yyyy-mm-dd_iiiiii.bak. If they have some other format then you must include that information in the question, and you may need to use other string methods like replace, substring... to remove the unnecessary part

# Microsoft Windows [Version 10.0.17134.648] 
# powershell 5.1.17134.48
# parse Notepad++ "backup on save" filenames.
# dir directory. Include index*,avail* where the last write time is less than
# 4 days. Display a parsed Name. Display the Length (size) and the LastWriteTime.
# Can be used as a shortcut: powershell -noexit $time = (Get-Date).AddDays(-4); gci * -include index*,avail* | where $_.LastWriteTime -gt $time | Format-Table @n='foo';e=$_.Name -replace '(?<=^.*.html).*$',Length,LastWriteTime -HideTableHeaders
# Start it in your directory of choice.

$time = (Get-Date).AddDays(-4)
gci * -include index*,avail* | where $_.LastWriteTime -gt $time | Format-Table @n='foo';e=$_.Name -replace '(?<=^.*.html).*$',Length,LastWriteTime -HideTableHeaders

Expected results:

available13.html 93130 3/26/2019 8 : 10 : 05 AM
index.html 39386 3/26/2019 8 : 10 : 05 AM

Actual results:

available13.html 93130 3/26/2019 8 : 10 : 05 AM
index.html 39386 3/26/2019 8 : 10 : 05 AM

See LotPings answer for the almost solution to the parse:
"I'd use a RegEx with zero length lookbehind assertion to remove
everything after html from $_.Name This can be done with a calculated
property either in a Select-Object or a Format-table". See the corrected solution below.

| Format-Table @n='foo';e=$_.Name -replace '(?<=^.*.html).*$',Length,LastWriteTime -HideTableHeaders