samjs

Word Count for Parsing

Discussion created by samjs on Dec 3, 2012
Latest reply on Dec 5, 2012 by beverly

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!

Outcomes