How to remove extra space/value from Choice Box

[panand99]

Hi All,

I have a string which is having value like : (in fig 1)a nd I have a choice field on which I its value display with blank values

I used split function - Split(TextInput2.Text,",")

I want result to be only with values

a

b

c

[CarlosFigueira · Accepted solution]

You can Filter the result of the Split function to return only those entries that are not blank. For example, the expression below returns only those that are not blank or whitespaces only:

Filter(
    Split(TextInput2.Text, ","),
    Trim(Result) <> "")