Functions for concatenation of fields into string
Fld1+“, ”+...+“, ”+FldN |
Convert fields to string, then concatenate with comma +space between fields, |
Fld1+“,”+...+“,”+FldN |
Convert fields to string, then concatenate with comma between fields, |
Fld1+“ ”+...+“ ”+FldN |
Convert fields to string, then concatenate with space between fields, |
Fld1+...+FldN |
Convert fields to string, then concatenate, |
Fld1+“-”+...+“-”+FldN |
Convert fields to string, then concatenate with hyphen between fields, |
Fld1+“ - ”+...+“ - ”+FldN |
Convert fields to string, then concatenate with space +hyphen+space between fields, |
Fld1+“, ”+Fld2+“ ”+Fld3 |
This is for “LastName, Firstname MI” format, |
Fld1+“ ”+Fld2+“. ”+Fld3 |
This is for “FirstName MI. Lastname” format. |