Get data from last line and merge into data stream before removing

Question

Post reply

Get data from last line and merge into data stream before removing

Ten Centuries

Points: 1043

December 4, 2020 at 4:23 pm

This script reads thru a file and removes the last line, but before it does that can I grab a value from that last row and add it

into my output stream? The value in the last line as an eye-catcher of $X and then grab the values from the 3rd position until

it hits the next delimiter(,).

Thx.

param
(
  [string]$path
)
$myFiles = Import-Csv -Delimiter '~' -Path $path -Header Path, ShortName
# Then you can call it like so
$myFiles.Path #Returns just the path
$myFiles.ShortName # Returns the shortname
$path='G:\AreaSistemi1\'
$count = 0
foreach ($myFile in $myFiles)
{
	get-childitem -path $myFile.Path *.spx | % {
       " Starting File Process....."  >> $myFile.Pathsistem.log
	   $PDate = get-date
       $date = get-date -uformat "_%d_%m_%Y_%H%M%S.bak"
       #"Set backup date to $date" >> $path\sistem.log
       $newname=($_.fullname -replace ".SPX",$date)
	   $file = [System.IO.Path]::GetFileNameWithoutExtension($_.fullname)
       "File backup name is $newname" >> $myFile.Pathsistem.log 
       Rename-Item $_.fullname $newname
	   "Renamed file to $newname" >> $myFile.Pathsistem.log
	   $lines = get-content $newname
	   
	  
	   $count = 0
	   
	   foreach ($line in $lines[0..($lines.length -2)]) 
	   
	   
	    {
			$line + " " + $myFile.ShortName  | Out-File "$path\sistem.csv"   -append
			$count ++
			
	    }		
       Write-Host $_.fullname 
      "Files Processed on $PDate are $newname and Lines Processed $count " >> $path\sistem.log
	}
}