Skip to main content
Solved

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

D
Forum|alt.badge.img+4

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!

Best answer by dilipborad

Hi @Damian_L 

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

See attached images.

View original
Did this topic help you find an answer to your question?

2 replies

dilipborad
Forum|alt.badge.img+20
  • dilipborad
  • Brainy
  • 217 replies
  • Answer
  • October 12, 2023

Hi @Damian_L 

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

See attached images.

3 Attachments
D
1 person likes this
  • D
    Damian_L
D
Forum|alt.badge.img+4
  • Damian_L
  • Author
  • New Participant
  • 1 reply
  • October 12, 2023

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

dilipborad
1 person likes this
  • dilipborad
    dilipborad

Reply


Most helpful members this week

Terms & Conditions