topic Escape asterix (*) in load statement in QlikView

Escape asterix (*) in load statement

Mon, 19 Mar 2012 20:35:41 GMT

Hi all,

I know this seems a simple question however I haven't been able to find a solution for the following loading only entries that do not contains '*'.

I'm trying to load data from QVD where one of the field (Description) contains '*' along with other characters. I would like to discard any rows with * in the Description. There are many purmutaions of the *.

ex.

*Dennis S

Dennis * Rad

*null (where null) is the string

Any help is apreciated.

Thanks,

Escape asterix (*) in load statement

jonathandienst — Mon, 19 Mar 2012 20:58:55 GMT

LOAD ...

Description,

...

From ....

Where Index(Description, '*') = 0;

Regards

Jonathan

Escape asterix (*) in load statement

Wed, 21 Mar 2012 18:21:46 GMT

Thanks Jonathan, This works!