Textjoin in AppSheet

[Amit_Jain1]

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 · Accepted solution]

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

[Amit_Jain1]

Thanks @Steve
It Worked