April 8, 200520 yr 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!
April 8, 200520 yr I would search for the space and divide it that way. I posted an example if you need it. Split_Text.zip
Create an account or sign in to comment