How to split two lines in one cell from Excel file

[dotnetfan]

Hi,

Recently I got Excel file and I found there are two lines in a single cell. Does it possible to get the second line? By using Qlik Sense, it will be combined as one row.

Thanks in advanced!

Richard

[uacg0009]

Hi Dotnetfan,
In script, you can use subfield(YourColumnName,chr(10),2) to get the second line value.
Please try.
Aiolos Zhao

[dotnetfan]

欧了, 谢谢!!

[uacg0009]

Hi,
If what I answered is correct, please mark it as "solution", so other people can know this question is solved.
Thanks
Aiolos Zhao