Building a Full Name from Component Parts


This example concatenates several fields in a single field, adding a space 
between each of the fields brought in.  The example puts together parts of a 
name to create the whole name in a single field.


Enter the following in the Program Spec:


Title: #1
First: #2
Middle: #3
Last: #4
Degree: #5
Full Name: #6 : IF #1 <> "" THEN #6 = #1;
                IF #2 <> "" THEN #6 = #6 + " "  + #2;
                IF #3 <> "" THEN #6 = #6 + " "  + #3;
                IF #4 <> "" THEN #6 = #6 + " "  + #4;
                IF #5 <> "" THEN #6 = #6 + ",  "+ #5;



Application:  The Full Name field can be merged into a form letter avoiding 
unwanted extra spaces between fields.  This can be a problem while merging the 
nameÕs pieces when any one of them is empty.  Paula L. Gomez merges fine but 
John Smith would have extra spaces around his non-existent middle initial.





























Q & A Application Note         Rev. 6/92           #2101   Page 1 of 1