AnsweredAssumed Answered

vbscript to split a name field into two separate fields

Question asked by tiamo on Feb 4, 2014
Latest reply on Feb 5, 2014 by tiamo
I have a table with a name field (where a name is like "John Smith") and I want to build a separate first_name and last_name fields. How can I populate each new field with just the first ("John) or last name ("Smith") using the original name field?

I'm fine with 2 sep scripts I plug into the field calculator for each new field, unless someone wants to suggest another way.