Compare

Compare Substring Value

This will compare the first value after a | in two files to verify if the value is the same in both files. Otherwise write an error message if.

# ** Run the following prior to executing locally **
# Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy Unrestricted -Force;

[string]$FileDate = Get-Date -Format "yyyyMMdd"
Write-Output $FileDate

$OutputFilePath = "${OutputFilePath}"  # Job Variable

$SourceFileName = $OutputFilePath+"[FILE NAME]_"+$FileDate
$SourceFileName2 = $OutputFilePath+"[FILE NAME]_"+$FileDate

if((Test-Path $SourceFileName -PathType Leaf), (Test-Path $SourceFileName2 -PathType Leaf)) #{"Files Exist"} else { "Files Do Not Exist" }
{
#Event Control File Data

$SourceFile = Get-Content $SourceFileName
$SourceFile | Select-Object -First 1
$SequenceNumberEvent = "0"

$StartPosition = ($SourceFile | Select-String "\|").Matches.Index
$StartPosition = $StartPosition+1
#Write-Output $StartPosition

$Length = $SourceFile.Length

$SourceFileWorking = $SourceFile.Substring($StartPosition, $Length-$StartPosition)
#Write-Output $SourceFileWorking

$EndPosition = ($SourceFileWorking | Select-String "\|").Matches.Index
#Write-Output $EndPosition

$SourceFileWorking = $SourceFileWorking.Substring(0,$EndPosition)
Write-Output $SourceFileWorking

#Plan Control File Data

$SourceFile2 = Get-Content $SourceFileName2
$SourceFile2 | Select-Object -First 1
$SequenceNumberEvent2 = "0"

$StartPosition2 = ($SourceFile2 | Select-String "\|").Matches.Index
$StartPosition2 = $StartPosition2+1
#Write-Output $StartPosition2

$Length2 = $SourceFile2.Length

$SourceFileWorking2 = $SourceFile2.Substring($StartPosition2, $Length2-$StartPosition2)
#Write-Output $SourceFileWorking2

$EndPosition2 = ($SourceFileWorking2 | Select-String "\|").Matches.Index
#Write-Output $EndPosition2

$SourceFileWorking2 = $SourceFileWorking2.Substring(0,$EndPosition2)
Write-Output $SourceFileWorking2

if($SourceFileWorking -eq $SourceFileWorking2) {Write-Warning "Files Do Match"}
}
else
{Write-Warning "Files Do Not Exist" }