ADF-How to suppress line feed (\n\r) from output file while using DelimitedText dataset

Mannur, Deepak 20 Reputation points
2023-05-11T06:13:31.5066667+00:00

I am extracting blob data from Salesforce and storing it in ADLS as DelimitedText format. However, I've noticed that a new line is consistently added at the end of each file, and I haven't found an option to suppress the next line feed (\n\r) in the output file. Can anyone offer a solution for this issue?

User's image

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,398 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,923 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,311 Reputation points Microsoft Employee
    2023-05-15T10:28:08.0833333+00:00

    Hi Mannur, Deepak,

    Thank you for posting query in Microsoft Q&A Platform.

    Its expected behavior. Once data gets loaded in to delimited file. You can try creating a dataset on that file. You will observe that your data comes correctly as last row is empty. It's actually not a row. Its end of content.

    Are you seeing any issues because of it to read that delimited file data?


1 additional answer

Sort by: Most helpful
  1. Mannur, Deepak 20 Reputation points
    2023-05-23T11:57:27.27+00:00

    Hi Maheer instead of new dataset I opted a ADF Web activity. It worked fine. API call is to fetch data from ADLS file and even that worked fine. Thanks for checking back on this. We can close this thread now.

    0 comments No comments