Unique NUMBERS in field

Question

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 Answer

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