Replacing a new line character

I’m getting a new line character as part of string in a relevance query output.

Or is there a way to split?

For ex: skkj324s02lxl234-00xl304 needs to be split by “02” and return the the first part of it.
If “02” doesn’t contain the whole string has to be returned.

preceding texts of firsts "02" of "skkj324s02lxl234-00xl304"

More specifically:

( preceding text of first "02" of it | it ) of "skkj324s02lxl234-00xl304"
4 Likes

This one works. Thanks