topic Re: Function which remove all characters in QlikView

Function which remove all characters

roee1983 — Mon, 05 Aug 2013 08:39:32 GMT

Hi all,

i have in my model a field calls "accounts" , this field has values with numbers & characters toghther or only characters.

how do i get rid from all the characters records ?

for exapmle:

bb_445642 = 445642

sales = delete from the field.

Thanks

Roee

tresB — Mon, 05 Aug 2013 08:49:27 GMT

try:

purgechar(accounts, '_abcdefghijklmnopqrstuvwxyz')

Not getting easier method yet.

MayilVahanan — Mon, 05 Aug 2013 09:00:39 GMT

Try like this

if(len(Keepchar(accounts, '_1234567890')) > 0, Keepchar(accounts, '_1234567890'), '') as accounts