Hi,
I hope someone may be able to help me. I get the feeling this one is quite simple for some reason I just cannot get my head around the logic and formulas. Maybe I am still mentally stuck in Excel mode.
Anyway, I have a long string which is delimited by commas. I need to split it out, remove duplicates and put it back as a string again.
Any ideas? It is case-sensitive, if that matters?
Yes it was that lol.. must have needed my morning coffee. Thanks both.
@Scott_UK ,
You might have an error because the code that @BhargavPatel provided is for textInput field, but you require the solution for the Text field?
Then the code would be
Concat(Distinct(Trim(Split(Text.Text,",")),Value),Value,",")
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
No matter, was operator error lol.
Thank you for the formula, that works perfect 🙂
Hi,
Thanks for the steer 🙂
However, I get an error 'there is an error in this forumula' but oddly it doesnt highlight in red or say what part is wrong. Any ideas?
@Scott_UK Try this:
Concat(Distinct(Trim(Split(TextInputCanvas1.Value,",")),Value),Value,",")
In my case, the input for TextInuptCanvas1.Value is:
1,1,1,2,2,2,3,4,5,6,7,8,9,9,9,0,0,0,1,1,3,3,4,5,6,7,8,9,10,11,12,13,14,11,11,12,and,AND,aND,And, And,And
And my output using the code I posted is:
1,2,3,4,5,6,7,8,9,0,10,11,12,13,14,and,AND,aND,And
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional