So we have a large number of text fields that we want to convert to number fields without losing data. We have a script to write to convert the text to numbers, so for example it was
so we converted Monthly to 12, weekly to 52 and yearly to 1, so far so good.
But when we take that and convert the field to a number field it just whips out the data
is there anyway way to make sure it saves the data when you convert the fieldtype?