topic Re: Small Problem in QlikView

Small Problem

Mon, 15 Sep 2014 08:41:45 GMT

hi ,

i have string like this "AChaa12ssdah" knw by use string funtions i need to get out put "AChasdh"

Re: Small Problem

MK_QSL — Mon, 15 Sep 2014 08:54:11 GMT

This can be done using Left, Right, Mid, KeepChar and Purchar String Functions... But it would be easy to answer if you provide us the logic behind the output...

Thanks

Re: Small Problem

sorrakis01 — Mon, 15 Sep 2014 08:59:40 GMT

Hi,

The only solution that I Know for your problem is:

You can concatenate the string using function Mid

Mid("AChaa12ssdah",1,4) +

Mid("AChaa12ssdah",8,1) +

Mid("AChaa12ssdah",10,1) +

Mid("AChaa12ssdah",12,1)

Mid Examples:

mid('abcdef',3 ) returns 'cdef'.

mid('abcdef',3, 2 ) returns 'cd'.

mid( Date,3 ) where Date = 970714 returns 0714

mid( Date,3,2 ) where Date = 970714 returns 07

Regards,

Re: Small Problem

Mon, 15 Sep 2014 09:00:39 GMT

hi manish,

purgechar ( 'AChaa12ssdah','12as' )

i can give like this but need to keep "a" "s" With one time thts why i strucked