Forum Discussion
Help white spaces at the end
- Anonymous4 years ago
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.