How to Replace Multiple Text Values in a Single Expression

  • 8 March 2016
  • 1 reply
  • 37 views

Badge +1

Hello

 

I'm looking to be able to replace multiple "tags" in a pargarph with values. 

 

For instance, I can use the following expression to replace one text:

Replace ( dataRawParagraph, *Gift Amount*, tbGiftAmount )

 

However, what if I needed to replace more than one text value in the same paragraph using just one expression?  I tried this:

Replace ( dataRawParagraph, *Payment Per Year*, tbPaymentPerYear ) And Replace ( dataRawParagraph, *Pledge Duration*, ddlPledgeDuration ) 

But the above expression still only replaces the first value *Payment Per Year* but not the second one *Pledge Duration*.

 

Thanks!


1 reply

Userlevel 3
Badge +10

You can "nest" Replace functions inside each other, so that the output of the first function is the text input for the next function.


 


16811iEBE5A0BB29A515F8.png

Reply