Using available String functions in BI you can get what you want. You need to focus how to determine the exact RULE to identify LINE2.
Do you have any specific length to pick?
The length Is picked based on the logic of the column, like I indicated in my example lines. Line 1 will make sure '~' isn't included.
I'm talking about LINE 2
Ohh, start where the '~' ends, but exclude it and have 10 characters
I dont think so 10 is good number!! what ever
try to find position of ~ and add 10 to it
so for LINE2 the expression should be substr(col FROM position of ~ FOR position of ~ + 10)
Thank you Srini,
Sorry I was out for the last few days, I will try your alternative and let you know.