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

9 replies
29 views

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"

mikes0011

Brainy

Concat is working fine, just make sure to view Raw Output... the formatted output seems to trim the (displayed) output value.

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

Please keep in mind - toString() merely takes the human-readable appian interpretation of a string output, then casts that as a string. The spaces seen between each semicolon aren't actually from the data, they're originally just there for readability. There's no reason to assume concat() would come up with anything like this, since concat() deals ONLY with the actual data in the array, not adding extra fluff for readability like the default output does.

The Expression Guru

S

suranjank225014Author

Participating Frequently

Thanks for the response, even I can see the spaces in raw output, but I'm expecting the same from formatted value to use at different places

peter.lewis

Employee

The formatted value is exactly what it sounds like - a formatted result. The raw result is what is actually used when you pass it to other expressions.