How do i truncate to a specific word

[medgamestar]

i have a long text how do i truncate it to the phrase “END HERE”
for example :
i need help END HERE please help me haha
how do i truncate that text to just i need help dynamically because the first phrase won’t always have the same length

[appedge]

Hi.

One option is to use the “split by” function.

In your example, if you choose to split by and specify “END HERE” as the text to split by, you’ll end up with two items - “i need help " and " please help me haha”. Then you can say use the first item in that list.

So it’ll look something like this:

Hope that helps?

James
AppEDGE

[medgamestar]

yes it did thank you very much