Spliting values in field

Hi

I have the field fullname in my database which is in the format

Mr John Smith

What I have been trying to do is to extract the Mr then the John then the Smith into 3 separate columns. Can anbody help please?

Thank you

Marcus

Dim an array
array = split([FullName]," ")
array(0) will contain Mr
array(1) will contain John
array(2) will contain Smith

marcuscoker said:

Hi

I have the field fullname in my database which is in the format

Mr John Smith

What I have been trying to do is to extract the Mr then the John then the Smith into 3 separate columns. Can anbody help please?

Thank you

Marcus

Click to expand...

If all your names follow this pattern then Fofa's suggestion should work. You would then do an update of the record from the three components. But what if someone's name is Ms Mary Jane Smith or Mr John Mc Intire or maybe Mr John D Rockefeller? If any names don't fit the exact pattern then you have a problem and will probably need to eyerball all the names anyway.

As a general rule of thumb I use 5 fields for names; Salutation (Mr, Mrs, etc.) First, Middle, Last and Suffix (Jr, Sr, etc.)

Thanks

Many thanks for your help, will give it a try now

Thank you

marcus