topic Re: Using variable value in replace function in QlikView

Using variable value in replace function

Fri, 26 Apr 2013 03:57:36 GMT

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.

Fri, 26 Apr 2013 05:52:40 GMT

create variable, vUser

=Concat(comment,';')

then use

replace(comment, $(vUser), '*******').

Sat, 27 Apr 2013 05:53:22 GMT

Hi Vishwaranjan,

I think the problem is with the SET vUser = PEEK('USERID', 0, 'userids');

It only returns one row, but I need it to look at all records in the list of UserIDs.

nilesh_gangurde — Sat, 27 Apr 2013 15:44:35 GMT

Hii beanz,

instead of set vuser use the Let vUser and that to in the For loop then you will able to get the all the userIds.

for Example.

//**********************************************************//

userid

load * inline [

USERID

C
D

];

let vRecord = NoOfRows('userid');

for i = 0 to (vRecord) -1

LET vUser = PEEK('USERID', 0, 'userids');

//**********************************************************//

The above script will give you the all the userids pass into vUser Variable.

-Nilesh

Sun, 28 Apr 2013 12:33:26 GMT

Thanks for the help.

I'm almost on the right track, but it seems to be giving me 2 lines. One with the replace and one without.

I just need to return the replaced record.

I've attached the .qvw , to show what it is returning.