help on cutting up a text in different fields

[dutchpete]

Hello,
can someone help me with the folowing problem,
every month i get a list of names, but the names are displayed like this.
mrs. a b c johnson - wilkinson, i cant work with this in access.
now i made a large query with the text-formulas to cut the name in four parts.
Isnt there an easy way(like VBA)to find the spaces and divide the name.because the query is becoming very large.
thanks in advance.
peter

 

[kaspi]

Hi Pete
If you are using Access 2K there is a very handy function Split. You can define a character you want for the split. The result is an Array of values.
If you are using access 97 you have to write your own function using Instr function.
However, you are not able to use this solution directly in a qry, you would have to loop throught the records.
Hope it helps
kaspi