When using <cfhttp> to get csv files for use as query objects:
<cfhttp url="http://myserver/testLF.csv" method="GET" name="theQuery" charset="utf-8"firstrowasheaders="Yes"></cfhttp>
There is an issue with Mac formatted files that have CR line breaks. Windows files (CRLF) and Unix files (LF) are recognized correctly in Lucee, but Mac (CR) files are not. All 3 file types work correctly in ACF. I have attached all 3 files types for testing and verification.