Skip to main content
December 6, 2024
Question

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

  • December 6, 2024
  • 9 replies
  • 0 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"

    9 replies

    mikes0011
    Brainy
    December 6, 2024

    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.

    December 9, 2024

    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
    December 9, 2024

    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.

    somasundaram.d
    December 9, 2024

    You can use the rule that uses concat directly in the necessary places, it will display only the raw output and not the formatted one

    December 9, 2024

    Thanks for your reply, I need it in expression rule not on UI and it is not for display on UI. I need to pass this value to an external system.

    somasundaram.d
    December 9, 2024

    Did you try passing the output to the external system? Is it getting formatted there?