I have sifted through Answers and have yet been able to find this break down. If it is already out there, please point me in the right direction.
I have thousands of records that have a field name of “Full Name”. This would include an individual’s ( Lastname, Firstname Middle ). In that order with the comma after last name.
We have built a new template to capture additional data that we have been missing and the new template redesign breaks out the Name fields into three individual fields of Lastname, Firstname Middle instead of Full Name.
So, assuming I would use Retrieve Field Values in workflow and convert to a Token value and then assigned the value to the new template fields, how do I break the “Full Name” field into three parts? Currently using version 9.
I also have the a need to be able to do the exact same thing with some document names, where I would break the format of the document name up and fill in the fields of a new template.