topic Re: How to remove '--'(special character) from the field? in QlikView

How to remove '--'(special character) from the field?

siva_boggarapu — Fri, 02 Sep 2011 09:45:33 GMT

Hello There,

I have a table where I need to exclude '--' which is not a null. Could you please advice how to fielter.

How to remove '--'(special character) from the field?

its_anandrjs — Fri, 02 Sep 2011 09:47:36 GMT

Hi,

You need to use the subfield command to exclude this type of symbols from the data.

Regards,

Anand

How to remove '--'(special character) from the field?

SunilChauhan — Fri, 02 Sep 2011 09:49:22 GMT

may be this one

Load *

from path where columnname<>'--';

How to remove '--'(special character) from the field?

its_anandrjs — Fri, 02 Sep 2011 09:50:17 GMT

Hi,

You need to write some thing like this code

=Subfield(ColA,'-',1) to exclude the symbol '--' from any data from the load script or any of the object level you are able to do that.

Reagrds

Anand

Re: How to remove '--'(special character) from the field?

its_anandrjs — Fri, 02 Sep 2011 09:52:05 GMT

Hi,

See the attached sample for clearity it is ok for you.

Reagrds

Anand

How to remove '--'(special character) from the field?

its_anandrjs — Fri, 02 Sep 2011 09:55:38 GMT

Hi,

In load script you need to write some thing like this

Temp:

load * inline

[

ColA

asasasfs--

dddd--

ddd----

fsfsf----

];

load

Subfield(ColA,'-',1) as CleanField

Resident Temp;

or in object level you need to put Subfield(ColA,'-',1) on any object like list box any other object

Regards

Anand

Re: How to remove '--'(special character) from the field?

its_anandrjs — Fri, 02 Sep 2011 10:28:20 GMT

Hi,

You need to do some changes in your load script or in onject level where ever you want it

put this code if you want to exclue from data like

ColA

fdfd

fdgdg

---

sads

Just put

If(ColA>Len(Chr(196)),ColA)

And if you want to remove it from any data which is like

ColA

asasasfs

dddd

dffa----

fsfsf

dasds--

dasa-----------

www

rrrrr

If(ColA>Len(Chr(196)),Subfield(ColA,'-',1)

See the attached sample file

Regards

Anand

Re: How to remove '--'(special character) from the field?

its_anandrjs — Sat, 03 Sep 2011 05:53:00 GMT

Hi,

If you got correct answer so mark it correct so other will not try it.

Regards

Anand

How to remove '--'(special character) from the field?

harleen_singh — Sat, 03 Sep 2011 07:20:37 GMT

Hello siva.boggarapu

use the PurgeChar (string,'-') function like this

if ur field or string is abc--cde

PurgeChar('abc-cde','-')

it will give output abccde.

thanks

Lavi

How to remove '--'(special character) from the field?

its_anandrjs — Sat, 03 Sep 2011 07:29:00 GMT

Hi,

If there are several types of symbols in the tring and you want to remove it you are able to remove it by the use of Purgechar( ) command like

If string are like

ColA

sdasdasd----

asd---dsds

----sds

you have to put Put a code like =Purgechar( ColA, ' - ' )

or if string are like

ColA

sdasdasd----

asd---dsds

----sds

---(((fdfd

you have to Put a code like =Purgechar( Purgechar( ColA, ' - ' ), ' ( ' )

if there is any type of symbol acording to that you have to use it.

Regards,

Anand

How to remove '--'(special character) from the field?

pho3nix90 — Mon, 05 Sep 2011 12:28:14 GMT

Hi, Subfield will work, but if you have a value that says for example fdf--af, then it will make the code to long, simple awnser will be

=replace(ColA,'--','')

or if it is a value that shows only -- and you don't want to show it in a char ect, use the following in expression:

=If(ColA <> '--',ColA)

Re: How to remove '--'(special character) from the field?

Mon, 05 Sep 2011 14:02:48 GMT

Ich werde ab 05.09.2011 nicht im Büro sein. Ich kehre zurück am

23.09.2011.

Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Verwertung des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt.

Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank!