Help white spaces at the end

[Syndicate_Admin]

Good afternoon everyone, I need your help because I have a problem with the blanks at the end of a text.

In the query editor in the column "Client" there are values that have a space at the end as you can see in the screenshot (Ej Acosta Andres Daniel .

After clicking "close and apply" and go to the data, the space disappears:

In the capture above you can not appreciate, but the space in the end disappeared! This becomes visible when I copy the data to an Excel.

Could someone help me how to make sure this doesn't happen?

Thank you!

Fred

[otravers]

Trim this column (Transform > Format in the ribbon):

https://docs.microsoft.com/en-us/powerquery-m/text-trim

[Syndicate_Admin]

Thanks for the help! In this case I need the space not to disappear so the Text.trim function would not be useful for this case.

Best regards

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

I create a sample to have a test and I can reproduce your result. The trailing spaces will disappear in data view after we click "Close & Apply".

As far as I know, when strings are imported into AS Engine, the trailing spaces are trimmed. So the disappearing of the trailing spaces is by design. Here I suggest you to replace the trailing spaces by other characters like "_".

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Learner27]

Hi @Anonymous ,

I have a similar requirement where I've included all the special characters in a Calculated Column. Could you please assist me? I've also posted a similar query in the forum.

Can you guide me on how to replace white spaces with specific special characters?

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Solutions-for-Trailing-Space-Trimming-Issue-in-Power-Query/m-p/3673619#M142545

Thank you.