topic Subfield Dynamically in QlikView https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846355#M1004330 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a field I would like to use a subfield function to select everything that comes after the first delimiter.</P><P></P><P>e.g 0987 Sugar Farm</P><P></P><P>In this case, I only want to get "Sugar Farm" using a dynamic function to accommodate records with more than 4 characters before the first delimiter and records that has more or less than two words after the first delimiter.</P><P></P><P>How can I do this?</P></BODY></HTML> Mon, 25 May 2015 17:41:48 GMT 2015-05-25T17:41:48Z Subfield Dynamically https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846355#M1004330 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a field I would like to use a subfield function to select everything that comes after the first delimiter.</P><P></P><P>e.g 0987 Sugar Farm</P><P></P><P>In this case, I only want to get "Sugar Farm" using a dynamic function to accommodate records with more than 4 characters before the first delimiter and records that has more or less than two words after the first delimiter.</P><P></P><P>How can I do this?</P></BODY></HTML> Mon, 25 May 2015 17:41:48 GMT https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846355#M1004330 2015-05-25T17:41:48Z Re: Subfield Dynamically https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846356#M1004331 <HTML><HEAD></HEAD><BODY><P>=Mid('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">0987 Sugar Farm', Index('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">0987 Sugar Farm',' '</SPAN>)+1</SPAN>)</P></BODY></HTML> Mon, 25 May 2015 17:42:59 GMT https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846356#M1004331 MarcoWedel 2015-05-25T17:42:59Z Re: Subfield Dynamically https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846357#M1004332 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Thanks Marco! You are always helpful.</P></BODY></HTML> Mon, 25 May 2015 17:47:25 GMT https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846357#M1004332 2015-05-25T17:47:25Z Re: Subfield Dynamically https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846358#M1004333 <HTML><HEAD></HEAD><BODY><P>Glad it helped.</P><P></P><P>have a nice day</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 25 May 2015 18:12:06 GMT https://community.qlik.com/t5/QlikView/Subfield-Dynamically/m-p/846358#M1004333 MarcoWedel 2015-05-25T18:12:06Z