What has changed in Excel/Qlikview re uppercase recognition?

[josephinetedesc]

Hi in December I was able to check in Excel that the contents of 2 cells were the same.  For example the filter would show  SKIN, or skin as different.  This meant that the data going into QlikView was "clean".  I think this has now changed?  Has anyone else noticed this "new feature" in Excel   ... Excel version: Excel 2013

Jo

[Anonymous]

May be better to ask on an Excel forum.

[NareshGuntur]

Yes. I have suffered this.

It shows as case insensitive.

[josephinetedesc]

Hi Bill

I only became aware because QlikView showed the different cases as different options.  I kept trying to find out why the poblem was occuring.

Jo

[Anonymous · Accepted solution]

If you want QlikView to make them all the same case wise then look at these QlikView functions :

upper(textexpression)

Forces upper case for all data in the expression.

Example:

upper( 'abcD' ) returns 'ABCD'.

lower( textexpression )

Forces lower case for all data in the expression.

Example:

lower( 'abcD' ) returns 'abcd'.

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

[Pasted from QV Desktop Help]