parsing text from one field to two

[Jacob]

Hello all,

I'm hoping this is the right forum for this question. I have a field that contains first and middle/maiden names. I'd like to write a script (or do something) that will take all the text in that field and divide it up between two fields; one for first name and one for middle/maiden name. Ideally, I could run something once and it would search through each firstName field until it found a space, then cut and paste everything after the first space into the middleName field.

Any hints?

Thanks!

[quillpro]

I would search for the space and divide it that way. I posted an example if you need it.

Split_Text.zip

[Jacob]

thanks, worked great