topic Re: How to ignore ';' in QlikView

How to ignore ';'

vanderson009 — Wed, 04 Mar 2015 11:20:36 GMT

Hi Community,

I have values in my field like Anderson; Villyee but i want display it on text box as Villyee Anderson,

How could i revert it by ignoring semicolon.

Regards,

Villyee

simenkg — Wed, 04 Mar 2015 11:24:58 GMT

In your script you can do this:

Load *,

trim(Subfield(Name,';',2)) &' '& Subfield(Name,';',1) as FullName

from Source......;

If you want to do it in the front end you can just use the same expression directly, but this will be slower:

=trim(Subfield(Name,';',2)) &' '& Subfield(Name,';',1)

alexandros17 — Wed, 04 Mar 2015 11:24:59 GMT

Purgechar(myString,';')

if you do:

purgechar('abcd;',';') it will return abcd

PrashantSangle — Wed, 04 Mar 2015 11:26:06 GMT

Hi,

Use PurgeChar()

Regards

sunny_talwar — Wed, 04 Mar 2015 11:26:42 GMT

To ignore the you can use Replace or PurgeChar.

Replace(FieldName, ';', '')

HTH

Best,

sunny_talwar — Wed, 04 Mar 2015 11:30:25 GMT

And to get exactly what you are trying to get, you can use the following expression:

=Trim(SubField('Anderson; Villyee', ';', 2)) & ' ' & SubField('Anderson; Villyee', ';', 1)

this will take you from Anderson; Villyee to Villyee Anderson

Best,