>Yes there is a finite list currently; however, more word could be added at later time. I am thinking maybe maintain a table of the list so my user can add new name to the list. I can alway dump the value from the table into an array to compare against string somehow. As far as character lengths, the answer is no, I have seen words as long as 8 characters. Thanks for replying
>
>Nick Patel

If you do not have an agreed upon length of the first entry... and you cannot get 'the gods of marketing' to agree on placing a space between the first entry and the second entry... then it is impossible to 'parse' unless you have a finite set of 'first entries' in a table.

If you can get any of these agreed upon conditions then you can use OCCURS, ATC and various string manipulation functions to parse the required entries.

In watching the performance of other parsing programs I believe Foxpro is much faster than ACCESS/VBA and Visual Basic 5/6. I have seen VB project managers allocate the parsing to a separate C++ dll because of VBs slow speed.

It sounds as though the parsing you require is very simple though.. and with proper information foxpro should be able to perform it quickly and easily