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! Go to Solution.
@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.
Actuallyโฆ it should remove duplicates as well. Though you can use UNIQUE(โฆ) as well for duplicates.
So how could one remove blanks in a list, but not remove duplicates?
@Fabian - If the list you have is something along the lines of {1, 2, 2, 3, โโ, โโ}, I am pretty sure I have used -{null}
at the end and been able to remove empties no problem. So try that.
But, fair warning, I think I have it set up to grab lookup values and if they donโt exist to put in a null value so it doesnโt generate any errors, but I think it should still work for you.
Thank you Dave,
I dinโt know that we can use -{null]
in expressions.
Just tried it out. Itโs working, but it hat the same side effect as -LIST("")
. It removes also duplicates.
Dang. Well, it was worth the shot.
And yes, I believe anywhere you could use โโ you can instead use null, which may help improve readability. Not sure if it could possibly create errors elsewhere though.
@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.
@Bahbus Thank you very much Dave. Thatโs a solution
Thanks also to @Heino_Matthee and @Jervz.
But in my real case Iโm extracting a list of test fragments (not numbers) from OCRTEXT().
Try Select(YourTable[column], true) - Select(YourTable[column], ISBLANK(column))
Hi Fabian, try this
EXTRACTNUMBERS(CONCATENATE([YourList]))
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |