Custom Row Delimiter in Azure Data Factory (ADF)

Question

I have a CSV file that terminates a row with Comma and CRLF. I set my dataset to ",\r\n" but when I ran the pipeline, it won't accept this, thinking it's multiple values in the delimiter... If I don't put the comma in the dataset row delimiter, when pipeline runs, it thinks that there's an unnamed header. Is it possible in ADF to have this combination as a delimeter (comma + crlf) - ",\r\n"?

FirstName,LastName,Occupation,<CRLF Char>

Michael,Jordan,Doctor,<CRLF Char>

Answer 1

Update:
When running the copy activity, I encountered the same problem as you.

1. Then I selcet Line feed(\n)as Row delimiter at Source.

2. Add Column mapping as follows:
   

3. When I run debug, the csv file was successfully copied into Azure SQL table.

---

I created a simple test. Do you just want ADF to read 3 columns?

1. This is the origin csv file.

1. In ADF, If we use default Row delimiter and Column delimiter settings, select First row as header.
   

2. We also can select Edit and enter \r\n at Row delimiter field.
   

3. You can import schema here.