How do i detect Alt + Enter at the end of the Cell?

[KimConcremat]

Hey everyone, a little help here 😅

I need to identify the "Alt+Enter" at the end of each cell, but Power Query automatically removes it whenever i do a Query, i don't want to remove it, i need the data without modifications.

I need it to do a Check of data integrity from 2 different db's, because one of the sources may have sometimes a "Alt +Enter" at the end of the cell...

i need the "Check" column from the example bellow, anywhere, but i need it working, in Power Query or Power Pivot or in a measure etc.

Basically this is an "Transformation" stage from an "ETL", maybe another software could do it better than inside Power BI, but right now i need it inside Power BI.
Example:

Description (Source A)	Description (Source B)	Check ( 'Source A' = 'Source B')
slurry pumps	slurry pumps	=[Description (Source A)] = [Description (Source B)]
waste management	waste management

Thanks in advance!

[BA_Pete · Accepted solution]

Hi @KimConcremat ,

I can't replicate your issue - my Power Query identifies that a value with 'Alt+Enter' (carriage return) on the end does not match the same value without it, although this is after I've forced the carriage return into the data.

However, here's some things you can try to assist in your scenario:

Make sure you select the following option to force PQ to display whitespace and newline characters:

If this helps to be able to see the carriage returns, you can then manage them using the #(cr) code to, for example, replace them with something more visible:

Note here I've used the advanced options, checked 'Replace using special characters', and selected 'Carriage Return' from the dropdown to populate the 'Value To Find' field.

The above operation changes this:

to this:

making them far more visible.

Be mindful that you may need to perform the same replace operation for Line Feeds ( #(lf) ) as well, as they will essentially appear the same in PQ, but are, of course, different.

Pete