How to read a csv where record separator is LF (only)

Question

New to Alteryx--hoping this is actually simple (but not finding this exact case in the existing questions related to "csv" files):

I want to read .csv files that come from a system that writes them with an LF ($0A) as the record delimiter.  Seems like the Input tool should have options to configure what the record separator is, but since it doesn't, I get the "too many fields in record #1" error.  I can read the records with a /0 delimiter and then use Text to Columns to split them up into columns by the "," delimiter, and then use a Select to rename the columns, but I have a lot of different files and this would be a real pain to manually rename all the columns.  Is there a way to get Alteryx to use the first record as "headers" and name the columns accordingly in this scenario with Text To Columns (or some other tool)?

All my files look similar to this:

Bill_Richardson · Answer

Just a final update on this.  Ultimately, I've come to the conclusion that the issue was not with the record separators.  In some files, I had the "too many fields in record #1" issue with CRLF separated files as well.  I used the excellent thread on "too many fields in record #1" at https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Too-many-fields-in-row-x-when-reading-in-a-csv-file/ta-p/9189?utm_medium=resultsgrid&utm_source=designer to solve the issue.  In particular, the idea of using the Dynamic Rename tool to get the true column names from the first record was most helpful.

Bill_Richardson · Answer

Yes, I tried 
.   Alone, it produces the same result as no delimiter (entire line becomes a row).  You can't combine 
 with anything because if you do, you get:

"Error: Input Data (1): Newline (
 escape) is only allowed for the complete delimiter: 
,"

DataNath · Answer

@Bill_Richardson have you tried using 
 as a delimiter?