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.