topic Re: Remove first character if Alphabet in QlikView https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25511#M511043 <HTML><HEAD></HEAD><BODY><P>Got this</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199404_Capture.PNG" style="height: auto;" /></P><P></P><P>Using</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>If(IsText(Left(Input, 1)), Mid(Input, 2), Input) as DesiredOutput;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Input</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E02-02-NEW</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E02-32-E</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E05</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 07</STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Thu, 12 Apr 2018 11:23:58 GMT sunny_talwar 2018-04-12T11:23:58Z Remove first character if Alphabet https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25509#M511041 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a requirement in which I need to purge character of a field value if the first character is an Alphabet. </P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="190"><TBODY><TR><TD class="xl63" height="20" width="87">Input</TD><TD class="xl63" style="border-left: none;" width="103">Desired Output</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">E02-02-NEW</TD><TD class="xl63" style="border-top: none; border-left: none;">02-02-NEW</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">E02-32-E</TD><TD class="xl63" style="border-top: none; border-left: none;">02-32-E</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">E05</TD><TD class="xl64" style="border-top: none; border-left: none;">05</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">07</TD><TD class="xl64" style="border-top: none; border-left: none;">07</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 12 Apr 2018 11:20:26 GMT https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25509#M511041 malimohammed 2018-04-12T11:20:26Z Re: Remove first character if Alphabet https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25510#M511042 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(IsText(Left(Input, 1)), Mid(Input, 2), Input)</STRONG></P></BODY></HTML> Thu, 12 Apr 2018 11:22:13 GMT https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25510#M511042 sunny_talwar 2018-04-12T11:22:13Z Re: Remove first character if Alphabet https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25511#M511043 <HTML><HEAD></HEAD><BODY><P>Got this</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199404_Capture.PNG" style="height: auto;" /></P><P></P><P>Using</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>If(IsText(Left(Input, 1)), Mid(Input, 2), Input) as DesiredOutput;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Input</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E02-02-NEW</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E02-32-E</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; E05</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; 07</STRONG></P><P><STRONG>];</STRONG></P></BODY></HTML> Thu, 12 Apr 2018 11:23:58 GMT https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25511#M511043 sunny_talwar 2018-04-12T11:23:58Z Re: Remove first character if Alphabet https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25512#M511044 <HTML><HEAD></HEAD><BODY><P>Thank you.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Works Perfectly.</P></BODY></HTML> Thu, 12 Apr 2018 11:30:06 GMT https://community.qlik.com/t5/QlikView/Remove-first-character-if-Alphabet/m-p/25512#M511044 malimohammed 2018-04-12T11:30:06Z