topic Re: Lower case for long string but not first digit.... in QlikView https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449557#M485072 <HTML><HEAD></HEAD><BODY><P>Thank you, I needed the Mid fucntion I was missing that..</P></BODY></HTML> Sat, 11 May 2013 02:48:19 GMT b_garside 2013-05-11T02:48:19Z Lower case for long string but not first digit.... https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449554#M485069 <HTML><HEAD></HEAD><BODY><P>I need to make sure the ones in green are lower case whiel skipping the Q.</P><P></P><P>I know its a nested fuicntion but not sure how to skip the first letter. total lenght is 37 digits including Q</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 421px;"><TBODY><TR><TD class="xl63" height="17" width="421"><SPAN style="color: #00ffff;">Q</SPAN><SPAN style="color: #339966;"><STRONG>c66e8037_1eb2_4b16_9b6d_18c9f2b44d73</STRONG></SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 10 May 2013 19:33:44 GMT https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449554#M485069 b_garside 2013-05-10T19:33:44Z Re: Lower case for long string but not first digit.... https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449555#M485070 <HTML><HEAD></HEAD><BODY><P>Look into the Lower() function.</P><P></P><P>and if you want to remove the first char, try mid(TEXT,2, 36).</P><P></P><P>So maybe combined like</P><P></P><P>=lower( mid( '<SPAN style="background-color: #ffffff; font-family: Arial; color: #00ffff;">Q</SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #339966;"><STRONG>c66e8037_1eb2_4b16_9b6d_18c9f2b44d73', 2, 36))</STRONG></SPAN></P></BODY></HTML> Fri, 10 May 2013 20:00:36 GMT https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449555#M485070 swuehl 2013-05-10T20:00:36Z Re: Lower case for long string but not first digit.... https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449556#M485071 <HTML><HEAD></HEAD><BODY><P>I ended up doing this since the Q cant be left truncated I just add back on once the string is lowercase.</P><P></P><P><STRONG>'Q'&amp;</STRONG>Lower( Mid('Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73'),2,36) )</P></BODY></HTML> Sat, 11 May 2013 02:46:54 GMT https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449556#M485071 b_garside 2013-05-11T02:46:54Z Re: Lower case for long string but not first digit.... https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449557#M485072 <HTML><HEAD></HEAD><BODY><P>Thank you, I needed the Mid fucntion I was missing that..</P></BODY></HTML> Sat, 11 May 2013 02:48:19 GMT https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449557#M485072 b_garside 2013-05-11T02:48:19Z Re: Lower case for long string but not first digit.... https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449558#M485073 <HTML><HEAD></HEAD><BODY><P>I think you can simplify this to</P><P></P><P>Capitalize( '<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73'</SPAN>)</P></BODY></HTML> Sat, 11 May 2013 10:05:28 GMT https://community.qlik.com/t5/QlikView/Lower-case-for-long-string-but-not-first-digit/m-p/449558#M485073 swuehl 2013-05-11T10:05:28Z