Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
280207 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
9 - Sun
9 - Sun

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
9 - Sun
9 - Sun

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 😁