topic Re: Remove the character Pre-fix Values in QlikView

Remove the character Pre-fix Values

Srinivas — Wed, 17 Sep 2014 12:36:00 GMT

Hi All,

I want remove pre-fix of charecter value in my list box,

like i have data

G952211223

G9522103

G95208434556

G95208389

G952082234

G952081

could you please help on this.

Best Regards

Munna

Re: Remove the character Pre-fix Values

tresB — Wed, 17 Sep 2014 12:38:10 GMT

=Right(Data, Len(Data)-1)

Or,

=Mid(Data,2)

Re: Remove the character Pre-fix Values

anbu1984 — Wed, 17 Sep 2014 12:45:38 GMT

Mid(Fld,4)

Re: Remove the character Pre-fix Values

ashfaq_haseeb — Wed, 17 Sep 2014 12:58:03 GMT

Hi,

Try

=keepchar('G952082234','0123456789')

Regards

ASHFAQ

Re: Remove the character Pre-fix Values

israrkhan — Wed, 17 Sep 2014 13:02:41 GMT

Have you tried KeepChar(), if you have to remove 'G'

keepchar ( 'C3g43','0123456789' ) returns '343'

Re: Remove the character Pre-fix Values

Srinivas — Wed, 17 Sep 2014 14:20:11 GMT

Hi Tresesco,

i don't want to remove other values see below data, wherever started with 'G' Those values remove pre-fix of that particular character(G)...Remaining values should be same.

G952211223 ,

F98652,

S887643,

FALSE,

TRUE,

G9522103,

G95208434556 ,

G95208389 ,

G952082234,

G952081

Advance Thanks

Munna

Re: Remove the character Pre-fix Values

jcampbell474 — Wed, 17 Sep 2014 15:22:10 GMT

If you're just removing "G", I would use purgechar for simplicity.

Syntax:

PurgeChar(<fieldname>, '[chars to remove]')

Your example: purgechar(G9522103,'G')

Re: Remove the character Pre-fix Values

anbu1984 — Thu, 18 Sep 2014 14:02:23 GMT

Purgechar removes all occurrences, not just prefix

=purgechar('G9522103G','G')

Re: Remove the character Pre-fix Values

anbu1984 — Thu, 18 Sep 2014 14:09:09 GMT

Mid(Name,If(Name Like 'G*',2,1))

If(Field Like 'G*',Mid(Field,2),Field)