Hi - My second beginner question today. I have imported data from the left hand table below but would like to end up with the second table i.e. deselect the row for H1 2019 and rename H2 2019 as 2019, then rename Est 2020 as 2020. Whats the quickest way to do this please?
Many thanks!
Year | Value | Year | Value | |
2017 | 100 | 2017 | 100 | |
2018 | 110 | 2018 | 110 | |
H1 2019 | 112 | 2019 | 115 | |
H2 2019 | 115 | 2020 | 120 | |
Est 2020 | 120 |
Solved! Go to Solution.
So you want to deselect anything with "H1" in it and also just take the year digits?
Yes please.
Yes that works - thanks very much.
So that I understand though - in the Regex tool under Regular Expression you have typed:
(\d+)$
What does each part of this expression mean?
The brackets keep everything you want to capture.
The \d is a digit
The + is "one or more"
and the $ means anchor to the end.
...so (\d+)$ means capture 1 or more digits at the end of string.
You could also use (\d{4}) which would capture first four digits in a row in the string.