Remove every instance of [xxx-xxxx-xxx] formula

[Damian_L]

Hello all,

I need a formula that will delete every instance of a string of characters between [] including the brackets. Basically I'm pulling a products from a database which is SKU code then the product name. Every SKU code is like the following [SHU-BATT-22-EU] SHURE BATTERY 22. Is there a way to remove any code between [] including the brackets so I am just left with the product name? Thanks in advance!

[dilipborad · Accepted solution]

Hi @Damian_L 

Use the Formula field and then use it as a separate entity

See attached images.

[Damian_L]

You are a legend! Thank you, it worked exactly as required 😁