2 Replies Latest reply on Dec 17, 2012 4:59 PM by JustinWhite

    Pulling data from a field based on data in 2 fields

    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