Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
DipeshVadgama
Contributor II

How to remove 1st line from string qlik

Hi,

I have a string like below example. I would like to remove its first line.

 

22.01.2019 07:51:25 UTC John, Kumar Rahul, Koti

Create a task xzy on or before xyz date. Give training to xyz people.

Create data backup process.

 

Labels (1)
4 Replies
nagarjuna_kotha
Valued Contributor II

Re: How to remove 1st line from string qlik

Describe your issue clearly with some sample data to get quick answer.

DipeshVadgama
Contributor II

Re: How to remove 1st line from string qlik

I Have a data for each row & one of the field contains big string like a paragraph. Therefore I need to remove 1st line of it, which can have dates, names, etc. Which not necessary for customers and just to show rest of the string in it.

MVP & Luminary
MVP & Luminary

Re: How to remove 1st line from string qlik

You will want to identify the first position of the newline character and split the string at that position using the mid() function. So something like:

mid(myfield, index(myfield, chr(10)) + 1)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

hirishv7
Honored Contributor

Re: How to remove 1st line from string qlik

Would be able to help, only if all the occurrences are clear. So that the solution can point what ever required. get some sample data of all occurrence .

“Aspire to Inspire before we Expire!”