Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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