like function

[#1]

is there a like function in qlikview?

I have a column called "bonus_description" and it has both letters and numbers in it, for example "new member 100% bonus"

what I want is to replace all "new member 100% bonus" to just "100%" and then do the same where there is 50%, 75% etc

[alexandros17]

Use match or wild match (see help)

[#3]

try with wildmatch() function...

look it on qv help

[tresB]

Use Keepchar() / PurgeChar() function.

[maxgro]

=replace(' new member 100% bonus','new member', '')

[Colin-Albert]

Try

     trim(replace(replace(bonus_description,'new member',''),  'bonus','')) as bonus_percent

[jvishnuram]

Hi Abbasi,

You can use Keepchar() function.

Use like this in your script

Keepchar('bonus_description','0123456789%').,

it will fetch all the records like you want.

[rustyfishbones]

Hi Zainab,

there are a number of options

Here are 2

PURGECHAR()

KEEPCHAR()

[#9]

thanks

[alexandros17]

Keep char works in this way:

keepchar ( 'a1b2c3','123' )  returns '123'

This is not "like" ...

Am I right?