I have a table with 3 columns delimited by whitespaces

```
A1 3445 1  24
A1 3445 1 214
A2 3603 2  45
A2 3603 2 144
A0 3314 3   8
A0 3314 3 134
A0 3314 4  46

```

I would like to compare the last column with the ID (e.g. A1) in the first column to return the string with biggest number. So, the end result will be like this.

```
A1 3445 1 214
A2 3603 2 144
A0 3314 3 134

```

I have done up to spliting the lines, but I don't get how to compare the line.
A help would be nice.