I am looping through a data type process variable using the a!forEach() function. The output is displayed in an email body. There is a trailing semicolon character after all but the last row Example:
this is some text;
this is some text
I have tried using the stripwith() function to remove the semicolon, but that does resolve the issue.
Discussion posts and replies are publicly visible
It seems that your a!foreach is returning an array, and that in the view that you have you get the ";"
For handling arrays, you can use the a!flatten(). You should five the a!forEach() as a parameter or the variable you use to store it.
if you want to replace it with a space, you can use joinarray()
https://docs.appian.com/suite/help/19.4/Appian_Functions.html
https://docs.appian.com/suite/help/19.4/fnc_array_a_flatten.html
Hi. What do you mean by "five the a!forEach()"?
The documentation you linked to says that data types would retain their structure in the a!flatten function. This may be the case here as a tried it and still had semicolons in the output.
I wrapped our function using joinarray() and that seemed to do the trick. Thank you for the help.
Example code
joinarray(a!forEach(items: pv!output,expression: "First Name: " & fv!item.property1 & ", Last Name: " & fv!item.property2), "")
You were returning not one string, but a list of 4 strings. Any user facing output displays the list of strings as a list in a string. It does this through implicit casting, which includes adding those super handy semicolons for you.
When you a!flatten(), you magically transform your list of strings . . . into a list of strings. It literally does nothing to an array that's already not nested.
joinarray() takes a list of whatever and crams them all into one string, with an optional separator, so you can replace semicolons with even more annoying @ or # or $ if you want to.