Locate Statement - ASA9 -
09-20-2010
, 05:11 PM
HI,
I have a column containing a string of data off which I want to
extract components of this data out by locating the spaces.
An example of the string is as follows:
99 Toyota AE Corona GLX
01 Mazda XE 323 GTi
I would like to select the word Corona and 323 from the two strings
which is the characters between the 3rd space and the 4th space.
I currently use a very drawn out combinations of multiple substring
and locate commands to achieve this.
Is there and easy command to locate the position of the 3rd space and
4th space which I might be missing?
Thanks
Roger |