topic Re: How to cut some word in App Development https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796266#M62452 <P>Hi Lisa,&nbsp;</P><P>It works !! Thank you so much.&nbsp;</P> Thu, 01 Apr 2021 06:04:38 GMT apichana 2021-04-01T06:04:38Z How to cut some word https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796249#M62449 <P>Hi,&nbsp;</P><P>&nbsp;I have a PR_No. as below and I would like to create a new field SR-No which cut SR out and have only "207145"&nbsp; , Please advise the syntax. Thank you.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichana_1-1617247083421.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52221i89F0E06B11E71497/image-size/medium?v=v2&amp;px=400" role="button" title="apichana_1-1617247083421.png" alt="apichana_1-1617247083421.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 01 Apr 2021 03:23:52 GMT https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796249#M62449 apichana 2021-04-01T03:23:52Z Re: How to cut some word https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796256#M62450 <P>TextBetween(PR_No, "SR", "_")</P><P>-Rob</P> Thu, 01 Apr 2021 04:01:14 GMT https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796256#M62450 rwunderlich 2021-04-01T04:01:14Z Re: How to cut some word https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796257#M62451 <P>Here is one way:</P><P>TextBetween(PR_No, 'SR', '_')</P> Thu, 01 Apr 2021 04:05:37 GMT https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796257#M62451 Lisa_P 2021-04-01T04:05:37Z Re: How to cut some word https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796266#M62452 <P>Hi Lisa,&nbsp;</P><P>It works !! Thank you so much.&nbsp;</P> Thu, 01 Apr 2021 06:04:38 GMT https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796266#M62452 apichana 2021-04-01T06:04:38Z Re: How to cut some word https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796267#M62453 <P>It works. Thank you so much.&nbsp;</P> Thu, 01 Apr 2021 06:05:49 GMT https://community.qlik.com/t5/App-Development/How-to-cut-some-word/m-p/1796267#M62453 apichana 2021-04-01T06:05:49Z