I am trying to create a formula that will search a string that looks like this every time (see below). The issue is the TIME PERIOD: changes, could change to Quarter to date, Period to date etc.. So in other words I need the name of the word after when it says Timeperiod:

Any help is greatly appreciated!!


(Calculation: NPS or Average) & (Question Group: ALL METRICS) & (Benchmark: All Restaurants) & (Timeperiod: Trailing 6 Weeks) & (Reporting Date: Response Date)