How do I get Carriage Return and Line Feed as a new column ?

[EaglesTony]

Hi,

  I have a table called "Final" and the last column is "Fix Version", what I want in PowerM to add a custom column "Fix VersionwithCRLF".

  Example if I have "FixVersion" as "123", I want "FixVersionwithCRLF" as "123<CR><LF>" (where CR is the carraige return character and LF is the line feed character).

[EaglesTony]

I have this logic:

= Table.AddColumn(#"Removed Columns", "CRLF", each [Fix versions] & "#(cr)#(lf)")

Is there a way in the transform to actually see these characters, as in the transform they appear blank for this new column called "CRLF"

However it doesn't seem like it is outputing CRLF in my data when I output it.

I even tried in PowerAutomate to add decodeUriComponent('%0D%0A'), but when I loo at the file in notepad++ it just has Linefeed after each line.

It seems the header row doesn't capture the Carriage Return and Line Feed.

[Greg_Deckler]

@EaglesTony [FixVersion] & "#(cr)#(lf)"

[EaglesTony]

How can I validate it truly has those characters in the new column, as it shows the column as blank ?

[EaglesTony]

I tried this:

= Table.AddColumn(#"Removed Columns", "FixVersionWithCRLF", each Text.Combine([Fix versions], "#(cr)#(lf)"))

However, the column has "Error" with the error message as:

Expression.Error: We cannot convert the value "" to type List.
Details:
Value=
Type=[Type]

[Greg_Deckler]

@EaglesTony I believe it is "#(cr)#(lf)"

[EaglesTony]

What would be the syntax to add it as a new column to tack it onto the end of "FixVersion ?