I am trying to parse a field that contains the dimension of packages into it separate components. The field is a text field with the length, width & height separated by “x”’s.
The issue is that the dimensions are not all the same number of characters. For example. One record may be 2.5x1.8333333x1.75 and another 1.66666667x0.75x1.
What I’m trying to do is pull the string up to the first “x” as the length, between the “x”’s as width and after the last “x” as the height.
Any ideas would be appreciated.
thanks in advance
Rick
The issue is that the dimensions are not all the same number of characters. For example. One record may be 2.5x1.8333333x1.75 and another 1.66666667x0.75x1.
What I’m trying to do is pull the string up to the first “x” as the length, between the “x”’s as width and after the last “x” as the height.
Any ideas would be appreciated.
thanks in advance
Rick