incorrectly creating new lines

[ERNER2000]

In my csv found this data have enter so its show new lines can i slove this issue 

1. I replace value enter to "," but  i cannt slove it
2.I setting show that pic 2 I cannt solve it
can u help me

sorry for my english

[Anonymous]

Hi @ERNER2000 ,

We really can't tell what's wrong just by looking at the screenshots. Can you replace the data in your csv with sample data and provide it to us? That way maybe we can run some tests in order to find a solution, thanks!

Best Regards,
Dino Tao

[ERNER2000]

Hi @Anonymous 
let
Source = Csv.Document(Parameter3,[Delimiter=",", Columns=21, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

[ERNER2000]

Its sample file
let
Source = SharePoint.Files("
https:xxx/"
, [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://xxx/")),
Navigation1 = #"Filtered Rows"{0}[Content]
in
Navigation1

[lbendlin]

Your settings appear correct. Maybe your source file is not in UTF-8 ?