Hello,
I have a little problem. My field contains the following kind of data:
100b1
100b2
100c
100d1
100d2
1a
1a1
1b
1000a
1000a1
1000b
I need to split this field into two fields. All the numbers before the first character must be a field and the remaining characters/numbers must be the second field.
Example:
1000b --> 1000 and b
1a1 --> 1 and a1
1b --> 1 and b
100d2 --> 100 and d2
When the numeric part of the field ends, The new field had to begin.
I don't know if this is possible, but if I can split this field, sorting and searching are a lot easier. It must be possible to search for a range. Eg 100b to 1000c. If the field isn't split, this search isn't possible.
I hope someone can help me with this.
Thanks.
Albert
[This message has been edited by raindrop3 (edited 01-10-2002).]
I have a little problem. My field contains the following kind of data:
100b1
100b2
100c
100d1
100d2
1a
1a1
1b
1000a
1000a1
1000b
I need to split this field into two fields. All the numbers before the first character must be a field and the remaining characters/numbers must be the second field.
Example:
1000b --> 1000 and b
1a1 --> 1 and a1
1b --> 1 and b
100d2 --> 100 and d2
When the numeric part of the field ends, The new field had to begin.
I don't know if this is possible, but if I can split this field, sorting and searching are a lot easier. It must be possible to search for a range. Eg 100b to 1000c. If the field isn't split, this search isn't possible.
I hope someone can help me with this.
Thanks.
Albert
[This message has been edited by raindrop3 (edited 01-10-2002).]