Remove data from text field that has matching data in another field

[btappan]

I have a table with data like what I have below that I am trying to clean up, where some lines have the brand or SKU, or sometimes both, mixed in with the description. I'd like some sort of function that says if the brand name is repeated in the description, to remove it from the description text. Same for if the SKU is repeated in the description. Addressing the left behind white space would be good too.

Brand|SKU#|Description
XYZ|123|XYZ 123 SHOCK DAMPER
ABC|456|ABC 456 WIPER ARM


QRS|789|OIL FILTER
JKL|888|888 TIRE
HIJ|999|HIJ LAMP

Desired outcome:
XYZ|123|SHOCK DAMPER
ABC|456|WIPER ARM
QRS|789|FILTER
JKL|888|TIRE
HIJ|999|LAMP

[Gicu]

Try something like Clean_Description:Trim(Replace(Trim(Replace([Description],[Brand],""),[SKU#],"")) in a select query first and if your happy with the results use an update query to clean the data.

Cheers,
Vlad

[btappan]

Once I realized it was missing a right side parenthesis it worked like a charm, thanks! Had to change to Trim(Replace(Trim(Replace([Description],[Brand],"")),[SKU#],""))

[Gicu]

Glad to hear, sorry, I've just free-typed it...