Removing Duplicate Values from rows

Kaish

I have a data set in which after concatenating my data I have few Values which are duplicated I want to remove only those duplicate values, the rest of the data will remain as it is like the "comma" will be present if there are unique values beside each other.

Input  Example -  A         B

                            1        802,802,903

                            2        903,709

                            3        654

                            4        802,789,802,789,903

Output Example - 

                            A           B 

                            1         802,903 

                            2         903,709 

                            3         654

                            4         802,789,903

Kindly help me to find the output. Thanks

shancmiralles

hi! @Kaish 

 use a formula tool.. create a new output column.. then use this formula:
regex_replace([field],"\b(\w+),(?=.*\b\1,?)","")

the [field] is your b column where the concatenated data  is!

hope this helps! 
and please mark this as a solution if it really help