topic Re: Substring function in QlikView https://community.qlik.com/t5/QlikView/Substring-function/m-p/434148#M161836 <HTML><HEAD></HEAD><BODY><P>subfield(Address,'/',1) as ipv4</P><P>subfield(Address,'/',2) as ipv6</P><P></P><P>HIC</P></BODY></HTML> Thu, 13 Dec 2012 12:58:55 GMT hic 2012-12-13T12:58:55Z Substring function https://community.qlik.com/t5/QlikView/Substring-function/m-p/434146#M161834 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333333;">Hi,</SPAN></P><P></P><P><SPAN style="color: #333333;">How can obtain two fileds : Addr. ipv4 and Addr. Ipv6 with substring function: <STRONG>253.109.102.236/FA80::61B7:A707:80B:4411</STRONG></SPAN></P><P><SPAN style="color: #333333; font-size: 8pt;">Addr. IPv4 : 253.109.102.236</SPAN></P><P><SPAN style="color: #333333; font-size: 8pt;">Addr. IPv6 : FA80::61B7:A707:80B:4411</SPAN></P><P><SPAN style="color: #333333; font-size: 8pt;"> <BR />Thanks for your help.</SPAN></P></BODY></HTML> Thu, 13 Dec 2012 12:49:37 GMT https://community.qlik.com/t5/QlikView/Substring-function/m-p/434146#M161834 2012-12-13T12:49:37Z Re: Substring function https://community.qlik.com/t5/QlikView/Substring-function/m-p/434147#M161835 <HTML><HEAD></HEAD><BODY><P>Somthing like this:</P><P>left(FIELD,index(FIELD,'/')-1) as IPv4,</P><P>mid(FIELD,index(FIELD,'/')+1) as IPv6,</P></BODY></HTML> Thu, 13 Dec 2012 12:58:23 GMT https://community.qlik.com/t5/QlikView/Substring-function/m-p/434147#M161835 m_woolf 2012-12-13T12:58:23Z Re: Substring function https://community.qlik.com/t5/QlikView/Substring-function/m-p/434148#M161836 <HTML><HEAD></HEAD><BODY><P>subfield(Address,'/',1) as ipv4</P><P>subfield(Address,'/',2) as ipv6</P><P></P><P>HIC</P></BODY></HTML> Thu, 13 Dec 2012 12:58:55 GMT https://community.qlik.com/t5/QlikView/Substring-function/m-p/434148#M161836 hic 2012-12-13T12:58:55Z Re: Substring function https://community.qlik.com/t5/QlikView/Substring-function/m-p/434149#M161837 <HTML><HEAD></HEAD><BODY><P>Thanks, mwoolf &amp; Henric.</P></BODY></HTML> Thu, 13 Dec 2012 13:04:59 GMT https://community.qlik.com/t5/QlikView/Substring-function/m-p/434149#M161837 2012-12-13T13:04:59Z