How to remove dynamic string

[maxloveiii]

How to remove dynamic string in format '{*ABC234*}' like this.

EG

'TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

'

.......

(Any records  may be haven't the dynamic strings)

Remove red colour

I try to used "Replace" function

EG

Replace('TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

','{'&TextBetween('TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>{1FDTSE026129}-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

','{','}')&'}','')

But it not work

Result : TSB Finish Goods-Stationary Battery-FDTSE026129-FDTSE026129<ZSFG>-CDEBE026001<ZSFG>{1FDTSE026129}-SDEBE026001<ZSFG>{2FDTSE026129}-AF45<ZSFG>{3FDTSE026129}-AF45_02<ZSFG>{4FDTSE026129}-AU45<ZSFG>{5FDTSE026129}-AG24<ZSFG>{6FDTSE026129}-LLG5<ZRM>{7AG24FDTSE026129}

Please provide for this problem.

MaxloveIII

[Gysbert_Wassenaar · Accepted solution]

See here for a solution. The discussion is about html tags, but it's the same problem. Just replace the < and > characters with your curly braces