Hi All, I have a scenario wherein my csv file has data with line breaks

ADF C2 1 Reputation point
2021-02-25T13:02:28.99+00:00

Hi All, I have a scenario wherein my csv file has data with line breaks. i want to process same data and connect with multiple csv and have to convert a single csv file but due to line break in input csv we are facing issue .
Please let me know if any solution for this

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,906 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,671 Reputation points
    2021-02-25T15:50:15.103+00:00

    Please check if the suggestion in below thread helps.

    https://learn.microsoft.com/en-us/answers/questions/91071/how-to-remove-line-breaks-from-excel-file-in-adf.html

    Mostly likely, it won't as you have CSV and when you try to import the data, it will be imported incorrectly.

    You will have to develop some customized solution and run it through azure function. This suggestion is also given in above question thread.

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments