Textjoin in AppSheet

expressions
(Amit Jain) #1

How Can I Use TEXTJOIN Function in AppSheet
Here Is Spreadsheet Formula

IF ([ColX] =“Abc”, textjoin(" ",1,"Xyz @ “& [ColA] &” - “&[ColB] , [ColC] , [ColD] , [ColE] &” @ " & Round ([ColZ] , 0) , [ColY] ), “”)

I want to Join Column In Some Cases May be Some Column can Be Empty
So To Avoid Extra Space in Output I want to Leave out Empty Column

Is This Possible in AppSheet Expression?
Waiting for quick Reply

(Steve Coile) #2
SUBSTITUTE(((LIST(...) - LIST("")) & ""), " , ", " ")
  1. LIST(...) is the list of values you want joined.

  2. (... - LIST("")) removes any blank items from your list. Unfortunately, also has the side-effect of removing any duplicates.

  3. (... & "") converts the list to a single Text value.

  4. SUBSTITUTE(..., " , ", " ") replaces the list item separators (" , ", space-comma-space) with the separator of your choice (" ", a single space).

1 Like
(Amit Jain) #3

Thanks @Steve
It Worked

1 Like