topic Re: How To Remove numbers if Starting with Character in QlikView

How To Remove numbers if Starting with Character

pra_kale — Tue, 01 Mar 2016 16:55:54 GMT

Hi,

How to remove numbers starting with character while uploading the data.

for e.g. in my data i am having numbers like 123457, 135678, AB12345, CD4566 then while uploading the data i not want numbers starting with character. currently I am doing this by trim(left(Numbers,1))<>'C' and trim(left(Numbers,1))<>'A'.

Can i am upload with a single condition only where numbers starting with characters are not get's uploaded.

Thanks in advance.

Re: How To Remove numbers if Starting with Character

sunny_talwar — Tue, 01 Mar 2016 16:58:07 GMT

May be this:

Where IsNum(Left(Trim(Numbers), 1));

Re: How To Remove numbers if Starting with Character

pra_kale — Tue, 01 Mar 2016 17:36:41 GMT

Thanks Sunny. It is working fine.