https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037413#M85468 <P>Hi All,</P> <P>I have values in variable like -</P> <P>3000001-77777</P> <P>344444-8888888</P> <P>444444</P> <P>My req to get the values like below in load script -</P> <P>77777</P> <P>8888888</P> <P>444444</P> Tue, 14 Feb 2023 03:31:05 GMT ashmitp869 2023-02-14T03:31:05Z https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037413#M85468 <P>Hi All,</P> <P>I have values in variable like -</P> <P>3000001-77777</P> <P>344444-8888888</P> <P>444444</P> <P>My req to get the values like below in load script -</P> <P>77777</P> <P>8888888</P> <P>444444</P> Tue, 14 Feb 2023 03:31:05 GMT https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037413#M85468 ashmitp869 2023-02-14T03:31:05Z https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037416#M85469 <P>Hi</P> <P>Try like below</P> <P>Data:<BR />LOAD SubField(F1, '-', SubStringCount(F1, '-')+1) as F1 INLINE [<BR />F1<BR />3000001-77777<BR /><BR />344444-8888888<BR /><BR />444444<BR />];</P> Tue, 14 Feb 2023 03:37:51 GMT https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037416#M85469 MayilVahanan 2023-02-14T03:37:51Z https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037447#M85474 <P>Don't forget that the 3rd parameter to subfield can be negative -- counts from right.&nbsp;</P> <P class="p1"><FONT face="courier new,courier"><SPAN class="s1">SubField</SPAN>(<SPAN class="s2">F1</SPAN>, '-', -1)<SPAN class="Apple-converted-space">&nbsp;</SPAN></FONT></P> <P class="p1"><SPAN class="Apple-converted-space">-Rob</SPAN></P> Tue, 14 Feb 2023 05:48:56 GMT https://community.qlik.com/t5/App-Development/Help-in-the-load-script-with-right-function/m-p/2037447#M85474 rwunderlich 2023-02-14T05:48:56Z