topic How to remove special character? in QlikView

How to remove special character?

soha1902 — Tue, 01 Jul 2014 05:17:07 GMT

Hi All,

I want to remove last two character from my field.

I know, I need to use PurgeChar() but the problem is, I don't know how to type this character.

Please find below image for clarification.

Please help me regarding this.

tresB — Tue, 01 Jul 2014 05:24:37 GMT

To exclude last two chararcters, try like:

=Left('ABCDE',Len('ABCDE')-2)

You can replace ABCDE by your field name.

its_anandrjs — Tue, 01 Jul 2014 05:25:08 GMT

You can try like below load script if in the fields it is last 2 words

Load

Mid(FieldName,1,len(FieldName)-2) as Newfield

From Location;

Or you can use purge char also.

See the small example

LOAD Site,Word, mid(Word,1,len(Word)-2) as NewWord;

LOAD * Inline

[

Site,Word

a,23fd

b,45fdsf

c,3fsdf

d,56fdsf

e,566fsdf

];

And you get in field NewWord

3fs

56fd

566fs

45fd