topic How to remove characters in between of strings? in QlikView

How to remove characters in between of strings?

harleen_singh — Sat, 03 Sep 2011 07:03:58 GMT

Hello,

my string is like this asa--sasfs

or it can be like this --asaa

or like this asdfa---

i want to remove this -- from my string.

how to do it??

thanks

Lavi

How to remove characters in between of strings?

kaushiknsolanki — Sat, 03 Sep 2011 07:07:05 GMT

Hi,

You can use PurgeChar() function.

like this.

=PurgeChar ('ABC ---- PQR','-')

Regards,

Kaushik Solanki

How to remove characters in between of strings?

Sat, 03 Sep 2011 07:09:19 GMT

Hi,

use PurgeChar()

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

HTH

Reg,

Shubhu

How to remove characters in between of strings?

its_anandrjs — Sat, 03 Sep 2011 07:31:25 GMT

Hi,

You have to use Purgechar like this

=Purgechar( YourField, ' - ' )

or for multiple

=Purgechar( Purgechar( YourField, ' - ' ), ' ( ' )

Regards

Anand

Re: How to remove characters in between of strings?

Wed, 14 Dec 2016 09:04:26 GMT

Hey Anand,

Is it possible to use the Purgechar function to delete characters from a string, without removing every similar character in that string?
Example:

Purgechar(Message, '_Chart: ')
This will delete every single _ , C, h, a, r, t, :, and spacebar from the 'message string'.

Is it possible to just erase the '_Chart: ' and keep the rest of the _,C,h,a,r,t,: in that string?

Thanks in advance!

Re: How to remove characters in between of strings?

tamilarasu — Wed, 14 Dec 2016 09:14:09 GMT

Ivo,

You can use replace function in that case.

Replace(Message, '_Chart: ', '')

Re: How to remove characters in between of strings?

Wed, 14 Dec 2016 09:32:57 GMT

That worked, Thanks!

Re: How to remove characters in between of strings?

tamilarasu — Wed, 14 Dec 2016 09:38:06 GMT

Not a problem .

Re: How to remove characters in between of strings?

syinarosely — Fri, 22 Feb 2019 04:17:45 GMT

i have something to ask...

The original string is "saya suka makan nasi"

How do i remove "saya" and "nasi" in this context?

Please share