Washing text / change placement

Question

Hi,

I have tons of titles of products that have the wrong brand name placement. Some can be at the start, middle and end of a title.

Is it possible to do a mass rename with alteryx to place the brand value as the first name? Example:

Title Wanted Title Brand NameWUE Philips Hue 2000-->Philips Hue WUE 2000 Philips Hue2800 Philips Hue WUE-->Philips Hue 2800 WUE Philips Hue 2100 WCA 8.4W-->Philips Hue 2100 WCA 8.4W Philips Hue

I do have a column with the brand name.

RolandSchubert · Accepted Answer

Hi @ErikH ,

if you have a list of all existing brands, you could Append the Brand field to the title, and use a Replace formula to remove the brand from the text (wherever it may be placed within the title) and add it to the beginning. Sample workflow attached.

Best,

Roland

sneha_bhiwagade1 · Accepted Answer

Hi Erikh,

You can solve using a formula tool.

New Tittle:

[Brand Name]+' '+REGEX_Replace(Replace([Title], [Brand Name],''), "\s+", " ")

Please check the attached workflow.

Thank You