https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531905#M438805 欧了, 谢谢!! Fri, 18 Jan 2019 06:32:18 GMT dotnetfan 2019-01-18T06:32:18Z https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531886#M438803 <P>Hi,</P><P>Recently I got Excel file and I found there are two lines in a single cell. Does it possible to&nbsp;get the second line? By using Qlik Sense, it will be combined as one row.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled1.png" style="width: 408px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4007i3AE676FF19F2203C/image-size/large?v=v2&amp;px=999" role="button" title="Untitled1.png" alt="Untitled1.png" /></span></P><P>Thanks in advanced!</P><P>Richard</P> Fri, 18 Jan 2019 05:09:25 GMT https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531886#M438803 dotnetfan 2019-01-18T05:09:25Z https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531894#M438804 Hi Dotnetfan,<BR />In script, you can use subfield(YourColumnName,chr(10),2) to get the second line value.<BR />Please try.<BR />Aiolos Zhao Fri, 18 Jan 2019 05:52:16 GMT https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531894#M438804 uacg0009 2019-01-18T05:52:16Z https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531905#M438805 欧了, 谢谢!! Fri, 18 Jan 2019 06:32:18 GMT https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531905#M438805 dotnetfan 2019-01-18T06:32:18Z https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531909#M438806 Hi,<BR />If what I answered is correct, please mark it as "solution", so other people can know this question is solved.<BR />Thanks<BR />Aiolos Zhao Fri, 18 Jan 2019 06:50:25 GMT https://community.qlik.com/t5/QlikView/How-to-split-two-lines-in-one-cell-from-Excel-file/m-p/1531909#M438806 uacg0009 2019-01-18T06:50:25Z