finding a specific word coming multiple times in a sentence

Regex

Text Mining

Accepted answers

Can you let me know the requirement, I have the input.

What is the expected output?

Logic to derive it?

Many thanks

Shanker V

This formula logic of mine is taking the first word "xyzzp" it find an giving me 45 char available right side of the wrod "xyzzp".

Substring([Field1],FindString([Field1],'xyzzp')+0,45)

Thanks,

Kuldeep