4 Replies Latest reply: May 19, 2016 5:18 PM by Carl Hjortsj� RSS

    Find Replace expression issue

    Carl Hjortsj�

      Hello,

       

      Im new to this forum

       

      I need to replace part of expressions in a several qwv files.

       

      it is the second if-argument that needs to be changed in all formulas:

       

      =if(TimeType='Actual',
      (
      sum(SignFC*[1110000000 Intangible assets])/1000),
      if(TimeType like 'E*',-sum(SignFC*[1110000000 Intangible assets])/1000)) 

       

      I need to replace TimeType like 'E*' to TimeType like 'FP*'

       

      I have tried to use the replace ALL function in the Expression overview but it does not work.

       

      the problem is the 'E*' part and i cannot simply just replace E so it has to be something like

      Find

      TimeType like 'E*

       

      Relace by

      TimeType like 'F*

       

      not to mess up formulas....Any ide how to solve this???

       

      A quick answer would be highly appreciated.