Forum Discussion

sarathD4s's avatar
sarathD4s
Frequent Visitor
3 years ago

Multiple CSV files having line breakse when combined

Hi All,

 

I am trying to load multiple csv file from a sharepoint folder and when this are combined the text within a particular column gets divided and creates a new row causing error in the sheet. It seems the error happens when the column contains long text that has line break between them

 

Snip of the sample text that gets divided.

 

Files are loaded from the sharepoint folder and combined in the normal ways

 

 

After these files are combined, there will be multiple rows as seen below which will be automatically created causing errors

 

 

 

Can someone help me with a solution for this.

 

Regards,

Sarath

 

data protection
General Comment
Need Help
Tips and Tricks

4 Replies

  • sarathD4s's avatar
    sarathD4s
    Frequent Visitor
    3 years ago

    Hi amitchandak , thanks for the reply, but clean and trim can only done once it been loaded.

    Here New rows are created when the files are loaded so there is no point using trim and and clean after that.

     

  • sarathD4s's avatar
    sarathD4s
    Frequent Visitor
    3 years ago

    Further to the issue, i understood, its the line break that causing the issue, i have found some threads online but i couldnt solve the issue

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi, sarathD4s 

      It is recommended to pre-clean these file data to ensure that these csv files from a sharepoint folder have the same data structure.

      You can check if the following thread helps.

      Combine CSV files 

      Best Regards,
      Community Support Team _ Eason