Foreach File in Files extract last line in file

PowerShell Help
1

Hello Partners,

Need to go through a list of files and save the last line of each file in another file

 all my attempts failed

TRY 1

[pre] foreach ($file in Get-ChildItem "C:\Users\Marcos\Documents\Adobe" -Tail 1 ) { $file+ $file.fullname }

[/pre]

TRY 2

[pre]

foreach ($file in Get-ChildItem "C:\Users\Marcos\Documents\Adobe") {
if ($arquivo -eq true) {
Get-Content -Tail 1
$file + $file.fullname }

[/pre]

2

Almost … :wink: … try this:

$ListOfLastLines = Get-ChildItem -Path 'C:\Users\Marcos\Documents\Adobe'  -File |

ForEach-Object {

Get-Content -Path $_.FullName -Tail 1

}

$ListOfLastLines | Out-File -FilePath ‘C:\Users\Marcos\Documents\Result.txt’

3

bro, its , very well, thanks so much.

I’ve been trying to learn how to work with powershell but I’ve had a lot of trouble

Thank you for your help

4

more one simply question ,

 

How can I add the filename before the last line?

I tried concatenating the variable + $ ListOfLastLines.FullName, but I returned some errors.

5

The proper way would be to create a custom object and export it as CSV file … like this:

$ListOfLastLines = Get-ChildItem -Path 'C:\Users\Marcos\Documents\Adobe' -File |

ForEach-Object {

[PSCustomObject]@{

FileName = $.FullName

LastLine = Get-Content -Path $.FullName -Tail 1

}

}

$ListOfLastLines | Export-Csv -Path ‘C:\Users\Marcos\Documents\Result.csv’ -NoTypeInformation