T
traygo
Is it possible to parse a field without knowing the number of
characters?
I want to sort a text field that is made up of a value that has a
number then Text then another number, such as:
27F821 or 1FD1222
where the first 'set' of charcters (the first number portion) will be
either one or two digit. The next 'set' (text) will be one or two
charcters (at least, I don't think there will be any that are more
than two characters), the last 'set' (number) will be 3 or 4 digit.
I'm not wanting to separate these into differenct fields, but am
wanting to do a custom sort by
first 'set' of numbers, last 'set' of numbers, middle text.
Is this possible without breaking the text into different fields?
Thanks, Josh
characters?
I want to sort a text field that is made up of a value that has a
number then Text then another number, such as:
27F821 or 1FD1222
where the first 'set' of charcters (the first number portion) will be
either one or two digit. The next 'set' (text) will be one or two
charcters (at least, I don't think there will be any that are more
than two characters), the last 'set' (number) will be 3 or 4 digit.
I'm not wanting to separate these into differenct fields, but am
wanting to do a custom sort by
first 'set' of numbers, last 'set' of numbers, middle text.
Is this possible without breaking the text into different fields?
Thanks, Josh