How to Extract required text from a huge text

Help
, , ,
1

Hi Guys,

I have text looks like below(which is quoted)
"Hi All,
What is passage in English?

a portion or section of a written work; a paragraph , verse, etc.: a passage of Scripture. a phrase or other division of a musical work.
Regards,
David
From: JhonAlex
a speech or written statement, usually formal, directed to a particular group of persons:"

Now i want the text from starting to the one which comes before “From:” i.e., i need output like below

Hi All,
What is passage in English?

a portion or section of a written work; a paragraph , verse, etc.: a passage of Scripture. a phrase or other division of a musical work.
Regards,
David

Anyone can help me on this.

Thanks in advance

1 Like
2

If you have particular text or string before or after that text you need, you can either use regex or string manipulations @krishna46111

3

Hi
we can use a simple split method like this
if the inputt is in a variable named str_input
then using a assign activity
str_output = Split(str_input,“From”)(0).ToString.Trim

Cheers @krishna46111

4

You can use this Regex and select first group