I want to fetch the campaign string from the column Tags in my table if the value in the title column also contains campaign word and put it into another column. I want to search for the word "Campaign" in the tags column (so that in future if new campaign tags are added I won't have to update my code) and if it is present, I want to fetch just the campaign string present and no other tags. I can't use the split column using delimiter because not every row has this tag.
Title Tags CampaignTagsWanted
Campaign Product A Campaign Jan, XYZ Tag Campaign Jan
Campaign Product B Campaign Feb, ABC Tag Campaign Feb