Lines of file with some empty ones!

Hello, I’m trying to retrieve several lines based on the relevancy code listed below, but I am getting one empty line as well. It’s odd that if I remove unique values from then there are many empty lines, even though I’m using trimmed strings, something must be missing.

Q: unique values of (if exists version of it AND (version of it >= "7.69.0" AND version of it <= "7.80.0") then pathname of it & " || " & version of it as string else "") of files (lines whose (it contains "libcurl") of file "C:\Program Files (x86)\BigFix Enterprise\BES Client\Curl_Results.txt" as trimmed string)
A: 
A: C:\Program Files\McAfee\Agent\libcurl.dll || 7.80.0.0
A: C:\Program Files\McAfee\Agent\x86\libcurl.dll || 7.80.0.0
A: C:\Program Files\Microsoft Office\root\Office16\ODBC Drivers\Salesforce\lib\LibCurl64.DllA\libcurl.dll || 7.78.0.0
A: C:\Program Files\Notepad++\updater\libcurl.dll || 7.79.1.0
T: 10.452 ms

Your ‘else’ clause is generating the empty strings - and the unique values gives you the single blank result.

You could use unique values whose (it > "") to remove the empty line

4 Likes

Thanks :slight_smile: