I want to transform the letters in two columns into numbers.
In the following example I want to change the letters in column 2 and 3 for numbers, so that
A is changed to
The first column may also contain the letters
G. These should not be changed.
Columns are separated by
Id_animal / Column1 / Column2 ID01 / A / B ID02 / B / A ID03 / C / A ID04 / A / G
The wanted output is:
Id_animal / Column1 / Column2 ID01 / 1 / 2 ID02 / 2 / 1 ID03 / 3 / 1 ID04 / 1 / 4