1 Reply Latest reply: May 20, 2013 4:08 AM by Gysbert Wassenaar RSS

    How to remove dynamic string

    Suphanya Phatthawaro

      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