Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,075 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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,