My study has variable trial_id which has data entered in two different ways:
trial_id
1.1
1.2
1.11
1.12
BH013
BH014
BH015
I want to get rid if the '1.' and the 'BH0' (BH0, not BHO), so that I have:
study_id
1
2
11
12
13
14
15
I've been checking out various ways of removing parts of strings but none quite seem to fit with the '1.' or the 'BH0". I would greatly appreciate advice on how to do this.
trial_id
1.1
1.2
1.11
1.12
BH013
BH014
BH015
I want to get rid if the '1.' and the 'BH0' (BH0, not BHO), so that I have:
study_id
1
2
11
12
13
14
15
I've been checking out various ways of removing parts of strings but none quite seem to fit with the '1.' or the 'BH0". I would greatly appreciate advice on how to do this.

Comment