Split Text Formula

[mmattar]

Hello all,

I am trying to achieve grabbing this bit out of an email, my approach is to capture all the text not including the "Info : " and put them into an array and then i can loop over it to grab what i want. The email comes in, in 2 cases:

first case:

Some text here and what i want to grab right under

Info : AAA BBB CCCC DDDDD EEEEEE
Info : FFFF GGGGG HHHHH IIIIIIII JJJ
Info : KK LLL

second case:

Some text here and what i want to grab right under with a new line

Info : AAA BBB CCCC DDDDD EEEEEE
Info : FFFF GGGGG HHHHH IIIIIIII JJJ
Info : KK LLL

Thank you

[v-litu-msft · Accepted solution]

Hi @mmattar,

Case 1 could use "Info : " to convert the string into an array, then use skip() function to remove the "some text here...":

skip(split(outputs('Compose'),'Info : '),1)

Could you please explain more about "Some text here and what i want to grab right under with a new line"?

What's the mean of new line?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mmattar]

Hey thanks for the reply, what i mean by this is,

"Some text here and what i want to grab right under with a new line"?

What's the mean of new line?

its just some random text to show that there is text above what i want to grab, sometimes right under it and sometimes with a newline in between."Some text here and what i want to grab right under with a new line"?

Initially i am trying to grab all the info data, and find the "HHHHH", but this could be placed in a different spot not always  the same spot in the email. But it is in the "Info : " 

[v-litu-msft]

Hi @mmattar,

If so, you could following these steps:

Firstly, initialize a new line variable as a separator to convert the text into an array.

Secondly, use the filter query action to extract these rows contains "Info : ".

You could have a try:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.