Functions for concatenation of fields into string

     For these functions the user may select multiple rows in the grid of the Columns pane, and then apply any of the options in the drop-down combo-box list. In general, all selected fields are first converted into string data type and then concatenated in the pattern defined by the selected function option. We list next these function options:

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.