topic Re: Ignore difference between small and capital letters in QlikView

Ignore difference between small and capital letters

Wed, 13 Mar 2013 11:18:18 GMT

Hi,

When creating a script which uses parts of the excel-filename as identification (all the files have the same filename-structure), QV differentiates between capital and small letters. Although they are the same and this difference should be ignored.

E.g.: "LETTER" doesn't equal "letter" during upload.

How can I include this in the script ?

Thanks in advance.

Re: Ignore difference between small and capital letters

alexandros17 — Wed, 13 Mar 2013 11:20:19 GMT

Use "Upper" keyword to make all words equal ...

Re: Ignore difference between small and capital letters

manideep78 — Wed, 13 Mar 2013 11:21:54 GMT

Use upper() and lower() functions in your script. so that you can convert your text data either in upper case or lower case format.

Eg:

Upper(Field_Name) as Field_Name