Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Small Problem

hi ,

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

3 Replies
MVP
MVP

Re: Small Problem

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

sorrakis01
Valued Contributor

Re: Small Problem

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,

Not applicable

Re: Small Problem

hi manish,

purgechar ( 'AChaa12ssdah','12as' )

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

Community Browser