Forum Discussion

ERNER2000's avatar
ERNER2000
New Member
1 year ago

incorrectly creating new lines

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

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      ERNER2000
      New Member
      1 year ago

      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's avatar
        ERNER2000
        New Member
        1 year ago

        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