I have this column in my table which I can’t change the format.
Actually, this should be an ordinal number, that’s what I am looking for to do.
The 1st part (17) is useless.
After that, I need to use to 2nd and the 3rd number and apply them a formula in order to find out the ordinal number.
298.3 is (298-3)*15+20
46.1 is (46-3)*15+20
My biggest problem here is how to split the column in order to get 3 “new” columns.
Someone could help me, please?
Thanks a lot!!!