topic Re: Test if a string contain any numbers in load script in QlikView

Test if a string contain any numbers in load script

louwriet — Tue, 13 Oct 2015 13:19:13 GMT

Hi,

I need to test if a string in a field contain any numbers , if yes then group it in 'OTHER' else if the string in field contain no numbers then the field value stay the same.

But there are no fix order for the number to appear in the string - so i cannot test spesific positions. String can look like 'HARBOUR' then it will remain 'HARBOUR' and in the case of 'HARBOUR77' it must change to 'OTHER'

At the end my field in the records will look like this

GroupName

=========

HARBOUR

PORT

OTHER

LOADDECK

OTHER

ect.....

it would be something like if(field1 = num(whatever) , 'OTHER', field1) as Groupname

Help would be appreciated

Regards

Louw

Re: Test if a string contain any numbers in load script

sunny_talwar — Tue, 13 Oct 2015 13:25:15 GMT

May be this:

If(Len(Trim(KeepChar(Field1, '0123456789'))) > 0, 'OTHER', Field1) as GroupName

Re: Test if a string contain any numbers in load script

m_woolf — Tue, 13 Oct 2015 13:27:31 GMT

If(YourField = purgechar(YourField,'0123456789'),'There are no numbers','There is at least one number')

Re: Test if a string contain any numbers in load script

louwriet — Tue, 13 Oct 2015 14:43:54 GMT

Thank you for both of you, Sunny T and M Woolf, both of the solutions you gave me worked.

regards

Louw

Re: Test if a string contain any numbers in load script

Daniel-PNW — Wed, 28 Feb 2018 21:57:05 GMT

Totally help me weed out my list of results!!! Thanks so much.