I am trying to regex parse dynamically.
I.e. my data is 2020 2021 Total
I want to pass it through the regex parse to split out the data into columns, one for each of 2020, 2021 and Total and then rename the columns dynamically.
My issue is that sometimes the data can be '2021 Total' instead and so I need the second regex parse tool in the attached workflow. However when I add this, the expression is not correct as it also parses the data that is "2020 2021 Total". Instead what I want is for the data to be returned as Null because it has 2 sets of numbers in.
Any help on this one would be much appreciated?