Skip to Content
0
Nov 25 at 01:28 PM

How to get unique values in comma separated string in BO?

79 Views

I have a column that contains comma separated value strings. Some rows show only unique values just by chance, but other rows show repetitions of substrings (note how AB-12XY35 is repeated a few times in the second row).

Column A

AB-12XY34,AB-12XY35

AB-12XY35,AB-12XY34,AB-12XY35,AB-12XY35,AB-12XY35,AB-12XY36

I want to get the unique values of each cell. Returned order does not necessarily matter. Expected output shown below:

Column A

AB-12XY34,AB-12XY35

AB-12XY35,AB-12XY34,AB-12XY36

I am wondering if there is any way to get the expected output via only SAP BO. Any help would be much appreciated.