topic Re: TRIM Function in Editor in QlikView

TRIM Function in Editor

Wed, 28 May 2014 13:04:26 GMT

Hi all,

I have a quick question, as you know, to avoid issues with case sensitivity it is important to due a TRIM and UPPER function of the field or fields that may have this issue.

I've not been able to test this since my designer course, but I do remember that if you enter the function in the editor that TRIM would do the same function as it does in Excel, take away any extra spaces inside and outside.

Example:

Apple Tree (added extra space after)

Apple Tree

That if I added TRIM UPPER, my list box would show for the two above:

APPLE TREE

Am I correct in this assumption?

Thank you

Re: TRIM Function in Editor

ashfaq_haseeb — Wed, 28 May 2014 13:15:34 GMT

Hi Ricardo,

You are right.

You can test the same by copying below code in your script editor.

load*,

upper(trim(Text)) as Text2;

LOAD * Inline

[

Text

Apple Tree

];

Regards

ASHFAQ

Re: TRIM Function in Editor

Wed, 28 May 2014 13:16:55 GMT

thanks very much

Re: TRIM Function in Editor

Wed, 28 May 2014 14:51:31 GMT

Additional question, will this function work for thousands of records?

For instance:

Apple Tree

apple tree

Apple tree

Maple Tree

maple tree

Maple tree

My list box, if using trim/upper in script editor would return only 2 values of APPLE TREE and MAPLE TREE, yes?

Re: TRIM Function in Editor

ashfaq_haseeb — Wed, 28 May 2014 14:59:10 GMT

Hi, yes it will work

you get 2 values because Qlikview stores only distinct values in list boxes.

Regards

ASHFAQ