Multiple CSV files having line breakse when combined

[sarathD4s]

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

[sarathD4s]

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]

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

[sarathD4s]

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.

[amitchandak]

@sarathD4s , You can use clean and trim on a column to remove newline character, but that will happen only when it is on row

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4