Search for a word within a string

Good afternoon everyone, how are you?

I need to search within a string for the words “SUPPORT” and “EXTRA” and filter.

For cases where there is Support, I would like a column written Support to be returned and for extras written extra.

It’s worth remembering that it doesn’t follow a standard.

Do you know how it can be done in the best way?

FMH-SJP-012024SUPPORT606750001

SUPPORTSOC-SP32024402930159(G)_136545

FMH-SJP-01EXTRA202460675_0001

EXTRASOC-SP32024402930159(G)_136545