topic Re: Purgechar ##65# in QlikView

Purgechar ##65#

Wed, 23 Nov 2016 07:58:34 GMT

Hello All,

I would like to know if the below will remove only the '##65#' or all '#', '6' and '5' values?

PurgeChar(ABCD, '##65#')

I need to remove just the '##65#' from my column ABCD.

Many Thanks,

Hasvine

tamilarasu — Wed, 23 Nov 2016 08:01:25 GMT

Hi Hasvine,

Yes. It will remove '#', '6' and '5' from your field. You need to use replace function in this case.

Replace(FieldName, '##65#', '')

Chanty4u — Wed, 23 Nov 2016 08:01:42 GMT

try this

aa:

LOAD * INLINE [

ABCD,sales

a##65#, 1

abbb##65#, 2

##65#b, 3

c##65#, 4

d, 5

];

LOAD *,

PurgeChar(ABCD,'#65') as new

Resident aa;

Chanty4u — Wed, 23 Nov 2016 08:02:24 GMT

Check this

prat1507 — Wed, 23 Nov 2016 08:02:29 GMT

Hi hasvine

It will remove all the '#', '6' and '5' values. Better use replace(ABCD, '##65#','').

Regards

Pratyush