AnsweredAssumed Answered

Using a range in Substitute function

Question asked by larrymcmunn on May 6, 2010
Latest reply on May 6, 2010 by comment_1

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.

Outcomes