Forum Discussion
Display text in table/matrix without removing whitespace
Hello everyone, I have some text that include some "manual" formating with \n and spaces. It seems to load correctly in the dataset: But when I use it in a visual like a Tab...
Hi Anonymous ,
The problem here is that the spaces get trimmed in this case you need to replace the space by the empty character.
You can copy paste from this link:
Has you can see below I have two rows one with the spaces and the empty character:
In this I have made a replace values:
Table.ReplaceValue(#"Added= Table.ReplaceValue(#"Added Custom"," ","<u+200f><u+200f><u+200e> <u+200e>",Replacer.ReplaceText,{"Custom"})nbsp;e.ReplaceValue(#"Added
nbsp;e.ReplaceValue(#"AddedThe text seems the same thing but is from the white space.
MFelix
Super User
Super UserHi Anonymous ,
The problem here is that the spaces get trimmed in this case you need to replace the space by the empty character.
You can copy paste from this link:
Has you can see below I have two rows one with the spaces and the empty character:
In this I have made a replace values:
= Table.ReplaceValue(#"Added Custom"," ","<u+200f><u+200f><u+200e> <u+200e>",Replacer.ReplaceText,{"Custom"})nbsp;e.ReplaceValue(#"Added
nbsp;e.ReplaceValue(#"AddedThe text seems the same thing but is from the white space.