4 Replies Latest reply: Apr 28, 2013 8:33 AM by Xena Gillham RSS

    Using variable value in replace function

      Hi all,


      I'm trying to strip out certain userid's from a comment, using the replace function.

      -attached is the sample .qvw



      First of all I create a table of possible userid's that could be found in a comment.

      Then I create a variable called vUser, using these values in this table of UserID's.

      Finally I want to be able to use this variable - vUser, in the replace function. replace(comment, $(vUser), '*******').

      The problem is that I want to be able to look through the list of UserID's and if it is found in the comment, then replace it with '*******'

      Like a find and replace.


      How could I go about this?


      Any ideas would be appreciated!


      Thank you.