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-01_2024_SUPPORT_60675_0001
SUPPORT_SOC-SP3_2024_40293_0159(G)_136545
FMH-SJP-01EXTRA_2024_60675_0001
EXTRA_SOC-SP3_2024_40293_0159(G)_136545