How to avoid new row creation for line feed from Power Query merging 100s of CSVs

RI 0 Reputation points
2023-07-10T10:36:45.8233333+00:00

I combine 100s of CSV files into one using Power Query. In my source files, there is one column that may contain a line feed (AKA line jump, line break). When my query detects the line feed, it automatically assumes it is a new row, which is incorrect.

My Transform File function is:

= (Parameter1 as binary) => let
        Source = Csv.Document(Parameter1,[Delimiter=",", Columns=17, Encoding=65001, QuoteStyle=QuoteStyle.None]),
        #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
    in
        #"Promoted Headers"

What should I add so that any line feed is maybe replaced by a space so that it doesn't create a new row?

Thanks,

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,075 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.