B
Beth
I have a text field that stores numbers that may occassionally have letters
after them. I need to be able to sort this field as if it is a number field
even though it holds text. Unfortunately, that is not something I have an
option to change, but I have to find a way to work with it.
The problem comes with the numbers 1-9 falling in the wrong place with the
text sort.
Does anyone have a suggestion on how to correct that in the sorting? The
only thing I came up with was very messy. That was to use nested if
statements to handle 1-9.
I am open to suggestions.
Thanks,
Beth
after them. I need to be able to sort this field as if it is a number field
even though it holds text. Unfortunately, that is not something I have an
option to change, but I have to find a way to work with it.
The problem comes with the numbers 1-9 falling in the wrong place with the
text sort.
Does anyone have a suggestion on how to correct that in the sorting? The
only thing I came up with was very messy. That was to use nested if
statements to handle 1-9.
I am open to suggestions.
Thanks,
Beth