topic Re: How to convert an alphabet to numbers in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87742#M605518 <HTML><HEAD></HEAD><BODY><P>Or may be this</P><P></P><P><STRONG>Match(INPUT, 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z')</STRONG></P></BODY></HTML> Sun, 15 Jul 2018 22:37:16 GMT sunny_talwar 2018-07-15T22:37:16Z How to convert an alphabet to numbers https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87740#M605515 <HTML><HEAD></HEAD><BODY><P>I wish to know if a function that does the following exists:</P><P>Input-&gt;Output</P><P>A-&gt;1</P><P>B-&gt;2</P><P>C-&gt;3</P><P>...</P><P>So on and so forth.</P><P></P><P>Thanks and regards.</P></BODY></HTML> Sun, 15 Jul 2018 15:23:08 GMT https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87740#M605515 julioarriaga 2018-07-15T15:23:08Z Re: How to convert an alphabet to numbers https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87741#M605517 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>=Ord(INPUT) - 64</P><P></P><P>like</P><P></P><P>=ORD('A')-64</P></BODY></HTML> Sun, 15 Jul 2018 22:01:33 GMT https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87741#M605517 swuehl 2018-07-15T22:01:33Z Re: How to convert an alphabet to numbers https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87742#M605518 <HTML><HEAD></HEAD><BODY><P>Or may be this</P><P></P><P><STRONG>Match(INPUT, 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z')</STRONG></P></BODY></HTML> Sun, 15 Jul 2018 22:37:16 GMT https://community.qlik.com/t5/QlikView/How-to-convert-an-alphabet-to-numbers/m-p/87742#M605518 sunny_talwar 2018-07-15T22:37:16Z