How do I remove all 1 and 2 character words from a field?

[andrewtrobec]

Hello,
I have a string field containing many words and I would like to remove all 1 and 2 character words from it. How do I do that? If my first sentence was the field value, the resulting output would be:

have string field containing many words and would like remove all and character words from

Best regards,

Andrew

[FrankVl · Accepted solution]

Add the following to your existing search:

| rex field=yourfield mode=sed "s/\b(\w{1,2})\b//g"

https://regex101.com/r/EPipoO/1

[andrewtrobec]

That's the one! Thank you!