how to clean up and convert ID column to number

My ID column has some extra values in it that make it a string (it's like ID1, ID2, ID3) . Is there a way in Symon to remove the ID and convert it to a number column ?

Comments