How to remove (; ) in the end of array in appian

Question

Hello everyone, for a few days I have a complication, I don't know how to remove the (; ) after each of the array 
 I have a rule that is responsible for extracting information and I build an array for each element, at the end I have an array of arrays that I print in a plain text document. 
 when I run my rule it returns something like this: 
 
 0WF20220210630 14 2/14/2022 22/04/20225678 n453049 MXP 1.00000020220445678 P 11556020122010081089 944,414.101234121212121231089 944,414.1000000000022023/06/2020 ; 0WF20220210631 14 2/22/2022 22/04/2022234567 n525487 MXP 1.000000202204ERTYUI P 11556020122010081089 777,777.801234121212121231089 777,777.8000000003042005/10/2020 ; 0WF20220210631

Mike Schmitt · Accepted Answer

This is just how Appian shows array data in raw output. What are you trying to do with it? If you're just trying to display each array member on its own line, you just need to use a function like joinArray(). i.e., joinArray(local!myArray, char(10)) would insert a newline character between each. Or whatever separator you'd rather use.

Naresh · Answer

Hi, 
 If you are planning to remove the semicolon (;) from the give text and want to return a list of items use split() function 
 ex: split("A;B;C", ";) will return 
 A 
 B 
 C 
 .

Mike Schmitt · Answer

this won't help if OP is getting raw array output (into which appian inserts the ";" between entries just as a delimiter for designer visibility). calling split() on the raw output won't do anything (since it doesn't actually contain any ";" characters), OR if they somehow call it on a flattened array output with the ";"s inserted between elements, it would appear to do nothing since it would merely split that flattened text out into a new array, then display that new array with its own new semicolon delimiters....

How to remove (; ) in the end of array in appian

Top Replies