How to remove 7 in that

[kulasekhar]

Hi All,

Load the following data into qlikview:

LOAD * INLINE[
F1

1234567

1234576

1234756

1237456

1273456

1723456

7123456

];

Need to filter the data where the values contain the digit ‘7’ in data above.

(remove 7 in that)

So output should be :

     F1

---------------

123456

123456

123456

123456

123456

123456

123456

Thanks,

sekhar

[Anonymous]

Hi,

Try

Replace(F1,7,'')

Regards,

Greeshma

[rubenmarin]

Hi Sekhar, you can use Purgechar():

LOAD PurgeChar(F1, '7') as F1;

LOAD * INLINE [

F1

1234567

1234576

1234756

1237456

1273456

1723456

7123456

];

[kulasekhar]

Hi Ruben,

result display only one row.like 123456 

Thanks

sekhar

[rubenmarin]

Hi Sekhar, there are many records with the same value, in a list box will show as only one value, if you add some another distinct field like "RowNo() as Number", and create a table box with those two fields, you'll see all records separated.

[kulasekhar]

ok

THanks

Ruben