topic Modifying a database to include uppercase characters in QlikView https://community.qlik.com/t5/QlikView/Modifying-a-database-to-include-uppercase-characters/m-p/462351#M1153150 <HTML><HEAD></HEAD><BODY><P>I am trying to figure out how to use Force Case upper on the load screen.&nbsp; I need to change a list of names from standard case to all Upper Case.&nbsp; Do you know how to apply this to Edit Scipts page?&nbsp; Also do you know how to remove a period from the end of a name?&nbsp; Thank you very much for your help.&nbsp; </P></BODY></HTML> Wed, 20 Mar 2013 21:37:44 GMT 2013-03-20T21:37:44Z Modifying a database to include uppercase characters https://community.qlik.com/t5/QlikView/Modifying-a-database-to-include-uppercase-characters/m-p/462351#M1153150 <HTML><HEAD></HEAD><BODY><P>I am trying to figure out how to use Force Case upper on the load screen.&nbsp; I need to change a list of names from standard case to all Upper Case.&nbsp; Do you know how to apply this to Edit Scipts page?&nbsp; Also do you know how to remove a period from the end of a name?&nbsp; Thank you very much for your help.&nbsp; </P></BODY></HTML> Wed, 20 Mar 2013 21:37:44 GMT https://community.qlik.com/t5/QlikView/Modifying-a-database-to-include-uppercase-characters/m-p/462351#M1153150 2013-03-20T21:37:44Z Re: Modifying a database to include uppercase characters https://community.qlik.com/t5/QlikView/Modifying-a-database-to-include-uppercase-characters/m-p/462352#M1153151 <HTML><HEAD></HEAD><BODY><P>You can use the Upper () function to get the desired result in the Load statement.</P><P></P><P>eg, LOAD Upper(Field1)&nbsp; would returnt he values in that field in all Upper case.</P><P></P><P>Can you be specific on the period thing. Is it from a field value loaded from database or something else.</P><P></P><P>Hope this was helpful.</P></BODY></HTML> Wed, 20 Mar 2013 21:56:40 GMT https://community.qlik.com/t5/QlikView/Modifying-a-database-to-include-uppercase-characters/m-p/462352#M1153151 2013-03-20T21:56:40Z