I have a text field where every row contains many product codes. One row might look like below (data is separated by ','):
12y,14c,23k,24t,12y
My problem is that many rows might contain duplicate (or more) product codes. From above example, product code 12y appear twice.
How can I automatically remove alla duplicate instances so that only one distinct product code remains on every row? In above example, 12y would have been removed automatically either from the end or the start.
Generally I think that using DISTINCT in combination with SUBFIELD() could solve the problem. But actually I'd deem it impudent to give more detailled advice without knowing more details.
Generally I think that using DISTINCT in combination with SUBFIELD() could solve the problem. But actually I'd deem it impudent to give more detailled advice without knowing more details.
