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

ADF C2 1

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

MarkKromer-MSFT 5,206 Reputation points Microsoft Employee

2021-02-25T17:44:51.427+00:00

Have you tried processing the file as "multiline rows" using the data flow activity in ADF? In the Source settings in ADF, the data flow has the multiline row option, may work for you here.
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee

2021-03-02T22:08:42.243+00:00

Hello @ADF C2 ,

We haven’t heard from you on the last response from Mark and Vaibhav and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee

2021-03-11T17:51:53.953+00:00

Hello @ADF C2 ,

We haven’t heard from you yet on the last response from Mark and Vaibhav and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

1 answer

Vaibhav Chaudhari 38,686 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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

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

1 answer