How to extract information from E-mail in the items "text content"

How To
1

Hello, I have a problem. I can’t find the right function for extract a word in E-mail to the app “hubspot”.
I just want the formula to use.

I want the word between two words.

Exemple text : This red house is very beautiful

I would like to extract the word “red” between “This” “and” “house”

I tried with the function “get” but I did not succeed

Capture d’écran 2023-03-05 032739
Capture d’écran 2023-03-05 0327391258×809 83.4 KB

I will wait for your answers, thank you :slight_smile: !!!

2

I recommend you should use the Regex code and the Text Parser module to match the pattern to get the desire text or the pattern.

1 Like
3

I agree, You must use a regex like this:

This\s+(\w+)\s+house

image
image294×574 24.5 KB

  • This - matches the word “This”.
  • \s+ - matches one or more whitespace characters.
  • (\w+) - matches one or more alphanumeric characters (letters or digits) and puts them in a capture group.
  • \s+ - matches one or more whitespace characters.
  • house - matches the word “house”.

Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

1 Like