Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
DipeshVadgama
Partner - Creator II
Partner - Creator 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
Partner - Specialist II
Partner - Specialist II

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

DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

HirisH_V7
Master
Master

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 .

HirisH
“Aspire to Inspire before we Expire!”