This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

New Bug Encountered: Minus LIST("") removes Duplicates in a List

Posted on 11-19-2019 08:32 AM
Fabian_Weller
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

Please consider the results in the Expression Assistant:

LIST(1,2,2,3) = 1 , 2 , 2 , 3

LIST(1,2,2,3) - LIST("") = 1 , 2 , 3

- LIST("") is meant to remove empty entries. But not to remove duplicates.

Solved Solved
0 9 571
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Bahbus
New Member
In response to Bahbus
Reply posted on --/--/---- --:-- AM

@Fabian I had another thought. I think I thought of a really annoying way to do it. As long as the list isnโ€™t huge, I think this should work decently.

SPLIT(TRIM(SUBSTITUTE(CONCATENATE([YourList])), ", ", ""))," ")

Try playing around with that.

View solution in original post

Jump to Solution
9 REPLIES 9
Top Labels in this Space