topic Re: How to separate Plant number from text in App Development https://community.qlik.com/t5/App-Development/How-to-separate-Plant-number-from-text/m-p/2046599#M86087 <P>Hi, one solution could be this.</P> <P>If(SubStringCount(Plant, '-') &gt; 0, SubField(Plant, '-', 1), '-') as [<SPAN class="lia-message-read">Plant number</SPAN>]</P> Wed, 08 Mar 2023 08:15:08 GMT BrunPierre 2023-03-08T08:15:08Z How to separate Plant number from text https://community.qlik.com/t5/App-Development/How-to-separate-Plant-number-from-text/m-p/2046498#M86081 <P>Hi Team,</P> <P>&nbsp;</P> <P>Load inline [</P> <P>S.no&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Plant&nbsp;</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11AM - COMPLETED</P> <P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1102 - COMPLETED</P> <P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7185-WF Completed</P> <P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11AC - WF Completed</P> <P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Not valid</P> <P>6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; completed</P> <P>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No STATUS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;]</P> <P>&nbsp;</P> <P>I need result like below for 5,6,7 i need '-' like mentioned below.</P> <P>&nbsp;</P> <P>S.no&nbsp; &nbsp; &nbsp; Plant</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11AM</P> <P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1102</P> <P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7185</P> <P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11AC</P> <P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-</P> <P>6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P> <P>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-</P> <P>&nbsp;</P> <P>Regards,</P> <P>Sra1.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Mar 2023 00:54:52 GMT https://community.qlik.com/t5/App-Development/How-to-separate-Plant-number-from-text/m-p/2046498#M86081 Sra1bandi 2023-03-08T00:54:52Z Re: How to separate Plant number from text https://community.qlik.com/t5/App-Development/How-to-separate-Plant-number-from-text/m-p/2046599#M86087 <P>Hi, one solution could be this.</P> <P>If(SubStringCount(Plant, '-') &gt; 0, SubField(Plant, '-', 1), '-') as [<SPAN class="lia-message-read">Plant number</SPAN>]</P> Wed, 08 Mar 2023 08:15:08 GMT https://community.qlik.com/t5/App-Development/How-to-separate-Plant-number-from-text/m-p/2046599#M86087 BrunPierre 2023-03-08T08:15:08Z