Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Describe your issue clearly with some sample data to get quick answer.
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.
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
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 .