Get text between special characters

This is going to be a little bit of a challenge and will depend on a few factors: whether the number of line is consistent (e.g. there are always 4 lines and whether it’s repeating), whether you’re always searching for the same words (fake, counterfeit) and whether they can show up multiple times.

To point you in the right direction. Here I first check whether the word exists then try to construct a MID by finding the start and end position of the string you’re trying to extract.

You can find whether the word you’re looking for is in the string by using the find() formula. If it is found, it’ll return a number, otherwise it’ll return an error.

Once you’ve found the word you’re looking for, you can find the end of the substring with find again find("//", {string}, {position where you found the key words}).

The tricky part is how do we find the beginning? Is it always preceeded by the word Lorem (or a set number of characters), you can just subtract it from where we find the keyword. Otherwise, you can extract every instance of “//” and then use the one that is closest to the position of the keyword you’re looking for.

See formula field reference

Hope this helps!

It does help indeed.

Thanks, @Aron!

To answer your questions:
The number of lines is not consistent
The preceding keyword is not always consistent.

I think I can get most of the way there with find.

Can anyone show me an example formula of how they would do this?

Many thanks