I have a global field where the First and Last Name are entered, and I want to parse it out to the First and Last Name fields. If there are 3 words in the global field, I want to grab the 1st 2 words and place them in the First Name Field, and the Last word in the Last Name field.
I've created a script using WORD COUNT, but it does not seem to be working for me. Does WORD COUNT not work on a global field?
Thanks for your help!