Deselect a specific record

[muns]

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

[PhilipMannering]

So you want to deselect anything with "H1" in it and also just take the year digits?

[muns]

Yes please.

[PhilipMannering · Accepted solution]

How about something like this?

[muns]

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?

[PhilipMannering]

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.