Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this Zainab
Use match or wild match (see help)
try with wildmatch() function...
look it on qv help
Use Keepchar() / PurgeChar() function.
=replace(' new member 100% bonus','new member', '')
Try
trim(replace(replace(bonus_description,'new member',''), 'bonus','')) as bonus_percent
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.
Hi Zainab,
there are a number of options
Here are 2
PURGECHAR()
KEEPCHAR()
thanks
Keep char works in this way:
keepchar ( 'a1b2c3','123' ) returns '123'
This is not "like" ...
Am I right?