Skip to main content
rodrigoc4881
rodrigoc4881
Participating Frequently
Apr 22, 2022 5:03 PM UTC
Question

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

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

3 replies

mikes0011
mikes0011
Brainy
Apr 22, 2022 5:12 PM UTC

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.

The Expression Guru
nareshs945
Inspiring
Apr 22, 2022 7:11 PM UTC

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

.

mikes0011
mikes0011
Brainy
Apr 22, 2022 7:15 PM UTC

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....

The Expression Guru
Terms & ConditionsAccessibility statement