Forum Discussion
Space between string concatenation in Power BI
Hello,
I would like to ask why it happens if space appears while concatenating two strings in power bi, making separate column in table.
Here I uploaded a picture, you see a space between Komtus and $ATS.ĮPL. How to resolve this issue? Trim, clean column didn't help.
Hi Analitika ,
You can refer the following links to "remove" the spaces in Power Query Editor by Replace Values feature...
= Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"Column1"})How to remove blank spaces with Power Query
Power Query – A function to remove spaces within Text values
Best Regards
2 Replies
Hi
What is the syntex you used? have you tried like below?
Thanks
Hari
Hi Analitika ,
You can refer the following links to "remove" the spaces in Power Query Editor by Replace Values feature...
= Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"Column1"})How to remove blank spaces with Power Query
Power Query – A function to remove spaces within Text values
Best Regards
