7 Replies Latest reply on May 6, 2010 1:11 PM by comment_1

    Using a range in Substitute function

    larrymcmunn

      Title

      Using a range in Substitute function

      Post

      Is there a way to specify a range in the Substitute function?

       

      I have three fields: OriginalText, RevisedText, and Date2Substitute.

       

      RevisedText is simply OriginalText with dates earlier than Date2Substitute replaced with Date2Substitute.

       

      Here is the RevisedText calculation I'm using to go back 75 years:

       

      Substitute ( OriginalText ; 

      [Date2Substitute - 1  ; Date2Substitute ] ;

      [Date2Substitute - 2  ; Date2Substitute ] ;

      [Date2Substitute - 3  ; Date2Substitute ] ;

      [Date2Substitute - 4  ; Date2Substitute ] ;

      [Date2Substitute - 5  ; Date2Substitute ] ;

      .... etc. for 75 lines)

       

      Thanks for any help.