I have a column of values such as
MyColumn
TextValue1
TextValue2
TextValue3
Jan 2016
Feb 2016
2020
2021
... I need to keep only those values that are formatted like mmm yyyy, so from the above, would keep
Jan 2016
Feb 2016
At first, I tried adding a column in Power Query,
=Date.FromText([MyColumn])
And then removing errors.
However, this keeps the 2020 and 2021 values, as PQ still sees those as dates.
I don't want to use the length as a test (such as testing that the length is 8 for mmm yyyy format), because it is possible that there could be leading/trailing spaces, like
" Jan 2015"
"Mar 2014 "
And I would need to keep those.
How else can I keep dates that are mmm yyyy but exclude yyyy entries?
Thanks
MyColumn
TextValue1
TextValue2
TextValue3
Jan 2016
Feb 2016
2020
2021
... I need to keep only those values that are formatted like mmm yyyy, so from the above, would keep
Jan 2016
Feb 2016
At first, I tried adding a column in Power Query,
=Date.FromText([MyColumn])
And then removing errors.
However, this keeps the 2020 and 2021 values, as PQ still sees those as dates.
I don't want to use the length as a test (such as testing that the length is 8 for mmm yyyy format), because it is possible that there could be leading/trailing spaces, like
" Jan 2015"
"Mar 2014 "
And I would need to keep those.
How else can I keep dates that are mmm yyyy but exclude yyyy entries?
Thanks