topic Regular Expressions in QlikView https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082228#M943594 <HTML><HEAD></HEAD><BODY><P>Hi Have below text and want to get the below value,</P><P></P><P>fdfdfd,gdgdg,ss,ffe,Sprint_01,fdgfg&nbsp; from this i want to get <SPAN style="font-size: 13.3333px;">Sprint_01 in load script</SPAN></P></BODY></HTML> Wed, 13 Jan 2016 18:10:11 GMT anuradhaa 2016-01-13T18:10:11Z Regular Expressions https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082228#M943594 <HTML><HEAD></HEAD><BODY><P>Hi Have below text and want to get the below value,</P><P></P><P>fdfdfd,gdgdg,ss,ffe,Sprint_01,fdgfg&nbsp; from this i want to get <SPAN style="font-size: 13.3333px;">Sprint_01 in load script</SPAN></P></BODY></HTML> Wed, 13 Jan 2016 18:10:11 GMT https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082228#M943594 anuradhaa 2016-01-13T18:10:11Z Re: Regular Expressions https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082229#M943595 <HTML><HEAD></HEAD><BODY><P>I guess you don't know the value Sprint_01 you want returned upfront, right? So what is the rule to find your value?</P><P>is it the second last value in the comma separated list?</P><P></P><P>=Subfield( YourField, ',', -2)</P></BODY></HTML> Wed, 13 Jan 2016 18:16:38 GMT https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082229#M943595 swuehl 2016-01-13T18:16:38Z Re: Regular Expressions https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082230#M943596 <HTML><HEAD></HEAD><BODY><P>Hi Anuradha</P><P>Can you please provide clear details. You want Sprint_01 in your load script for that you need a value. So from where you are gonna get that value?? </P></BODY></HTML> Wed, 13 Jan 2016 18:21:12 GMT https://community.qlik.com/t5/QlikView/Regular-Expressions/m-p/1082230#M943596 2016-01-13T18:21:12Z