Search for brackets

[stocktsi]

I have a data field that I'm trying to clean up. The field contains two references to the same information (gender and mens/boys) and I'd like to remove one reference so it's not repetitive and saying the same thing. Example of current data:

[Gender] MB Shoe - or - MB [Gender] Shoe

I'd like to replace both of those examples with just:



[Gender] Shoe

The bracketed text is replaced by another application so I want to keep it. Prefer to use a query to do this so I can contract/expand the scope of the query as necessary, but open to a search/replace on the table as well.

This can also be done in 1 query that covers both examples, or if it's easier 2 queries with each query covering one of the examples.

Thanks in advance for your help.

[stocktsi]

... and I can't just replace the letters MB because the letter combo is used elsewhere (coMB, etc).

[ajetrumpet]

... and I can't just replace the letters MB because the letter combo is used elsewhere (coMB, etc).

then try replacing any combo you can think of that will fit every record. surely you've thought of that?

like:

• [space]MB
• MB[space]
• [space]MB[space]

this is a pattern-based query need. so find the patterns.

[stocktsi]

The killer is that I have other records that have MB that I don't want to replace (as in "512 MB RAM") so none of the simple replaces work. I need to know the records also have [Gender] in it to know the MB is mens/boys not something else.