Help

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

Topic Labels: Formulas
Solved
Jump to Solution
278195 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Damian_L
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
dilipborad
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi @Damian_L 

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

See attached images.

See Solution in Thread

2 Replies 2
dilipborad
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi @Damian_L 

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

See attached images.

Damian_L
4 - Data Explorer
4 - Data Explorer

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