Unique NUMBERS in field

[urorar]

HI there.

I have data that is coming in a single field that holds several numbers, without delimiters,  example:

111112223333444

Is there a way to select unique numbers ? The output should be 

1234

I saw this post   but is not filtering unique numbers... Any ideas would be greatly appreciated.

[mattreynolds · Accepted solution]

Leveraging the great Stack Overflow post in your reference and modifying for the numbers (and no commas), this regex seems to work well:

regex_replace(input,"(\d+)(?=.*\1,?)","")

Example workflow with tests is attached.

If this is what you're after, please mark as solution - if not, happy to revise.

Thanks!

Matt

[urorar]

Simply the best, better than all the rest 🙂