I am trying to import data from a sharepoint list and storing it into a blob storage account as a csv file.
I am having trouble with the line break and rows. Some of the rows have symbols like '' or ' " '. This is causing line break and the data after that is loaded into a new line.
For example - While I did not directly receive the email discussed above, I did have the email read to me \Sort me out\ we can chat on phone
Output -
Row 1 - While I did not directly receive the email discussed above, I did have the email read to me
Row 2 - Sort me out
Row 3 - we can chat on phone
I have tried to do mapping columns in the pipeline but still having the same issue.
Please help me out.
Thanks