I have a .csv that I am looking to perform checks on before sending it to an RPA tool to automate an ETL process. The purpose of this script will be to validate each .csv for two strings, separated by a comma, and the 3rd data value is an integer. The first row is column headers and should be ignored. The sheet looks like this (Note that there ARE commas inside of the second string).

Each row MUST contain two strings of text and a number at the end – if any data is missing from each row we’d expect that to be a failure

ProductName,Description,Value
"Product Number One","This is a description for product number 1, released 5/3/2024",3.4563
"A different Product Number","This is a description for product number 2, released 3/2/2025",5.3200
"This is another product","Another unique description, released 6/3/2022",5.0000

I attempted to use this script, but I couldn’t get it to work with even one data set let alone 3. It seemed to return condition 0 below no matter what unless I changed it to match which would not work

$File = 'c:testFileNameHere.csv'
$Contents = 'ProductName'

If (Get-Content $File | foreach {$_ -like $Contents}) 
{
    echo "File check successful"
    EXIT 0
}
else
{
    echo "Error with source file - manual review is required to proceed"
    EXIT 2
}

Any ideas?