One method might be to first split the "DAILY Weather" field with a space as the separator.
The brute force method would be then to have eight versions of your calculated field above,
one for each level of split, and then concatenate the results together.
A second method would be to pivot the data after the split, described here:
A third method would be to try to use Tableau Prep to perform the split and pivot.