array to text

Question

Team, I have below code : a!localVariables( local!data1:{"test1
","test2
"}, local!data1) Output is list of text strings "test1
"(Text) "test2
"(Text) I want the output to be in format "tetst1
test2
" Basically i am formatting a data before sending into email template but it is appearing like below , i want the semicolon to be removed. Test1 ; Test2 It should be like below Test1 Test2 ANy suggestions ?

mikes0011 · Accepted Answer

a!localVariables( local!data1:{"test1", "test2"}, joinArray(local!data1, char(10)))will result in:test1
test2
To get rid of the HTML break tags you will need to do a subsequent line-by-line command such as stripHtml(), though I don't presume to know exactly what you're hoping to have happen with HTML formatting in your input text. FYI appian won't format HTML as rich text without some pretty significant user-defined parsing, etc, which gets pretty complicated to set up.

stewart.burchell · Answer

In answer to your first question you can use fn!joinarray():

fn!joinarray(
  a!localVariables(
    local!data1: { "test1
", "test2
" },
    local!data1
  )
)

If you want to have the output actually on separate lines (as is indicated by your second question) then you can loop through your input items and append a "new line" Unicode character to all items except the last item:

a!localVariables(
  local!myList: { "Test1", "Test 2", "Test 3" },
  local!myResult: fn!joinarray(
    a!forEach(
      items: local!myList,
      expression: if(
        fv!isLast,
        fv!item,
        concat(fv!item, char(10))
      )
    )
  ),
  { a!paragraphField(value: local!myResult) }
)

Sign up

Login with SSO

Login to the community

Login with SSO