topic correcting typos in script in QlikView https://community.qlik.com/t5/QlikView/correcting-typos-in-script/m-p/384851#M1166152 <HTML><HEAD></HEAD><BODY><P>We have a situation where spelling mistakes and capitals are causing repeat site names when I link QV to one of my databases.</P><P>Unfortuately the field in the db is free text and not a drop down. Can I fix this in the QV script so there is only one occurrence?</P><P></P><P>e.g uses are entering SITE A, Site A, site a and ste A (these are all the same sites)</P><P></P><P>Thanks</P></BODY></HTML> Thu, 06 Sep 2012 10:38:54 GMT 2012-09-06T10:38:54Z correcting typos in script https://community.qlik.com/t5/QlikView/correcting-typos-in-script/m-p/384851#M1166152 <HTML><HEAD></HEAD><BODY><P>We have a situation where spelling mistakes and capitals are causing repeat site names when I link QV to one of my databases.</P><P>Unfortuately the field in the db is free text and not a drop down. Can I fix this in the QV script so there is only one occurrence?</P><P></P><P>e.g uses are entering SITE A, Site A, site a and ste A (these are all the same sites)</P><P></P><P>Thanks</P></BODY></HTML> Thu, 06 Sep 2012 10:38:54 GMT https://community.qlik.com/t5/QlikView/correcting-typos-in-script/m-p/384851#M1166152 2012-09-06T10:38:54Z Re: correcting typos in script https://community.qlik.com/t5/QlikView/correcting-typos-in-script/m-p/384852#M1166153 <HTML><HEAD></HEAD><BODY><P>you can use capitalise(Field name) it will give Site A for all but unfortunately not for ste A</P></BODY></HTML> Thu, 06 Sep 2012 10:42:53 GMT https://community.qlik.com/t5/QlikView/correcting-typos-in-script/m-p/384852#M1166153 rajni_batra 2012-09-06T10:42:53Z