AnsweredAssumed Answered

Pulling data from a field based on data in 2 fields

Question asked by JustinWhite on Dec 17, 2012
Latest reply on Dec 17, 2012 by JustinWhite

Title

Pulling data from a field based on data in 2 fields

Post

     I import data where sometimes the persons name is in 1 field "Full Name" and sometimes I get the name in 3 fields "First", "Middle", "Last".   I want to create a field "Final Name" that populates the field with the  persons full name regardless of what method the persons name was imported.  However I do sometimes import all 4 fields "Full Name", "First", "Middle", and "Last" just in case the solution needs to know that info.

     I dont even know what type of function I would need to search for in order to learn how to accomplish this.

     Thanks in advance,

     JW

Outcomes