How to concat extra spaces other than using concat function in a value?

Certified Senior Developer

How to concat extra spaces other than using concat function in a value.

To convert a list of text strings to a string, concat is not working if it has multiple spaces in a sequence. 

Eg: {"a"," "," "," "," "," "," ", "b"}

Actual output

using concat is "a b"

using to string function "a; ; ; ; ; ; ; b"

Expected output

"a      b"

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data