Delimiter

Used to separate…

Semi-colon (;)

●      Multiple values of a multi-valued field

●      Multiple values when multiple records are selected

●      Multiple values of multi-valued fields and multi-record selection

Comma (,)

●      Multiple display fields of a non-qualified lookup field

●      Multiple nested display fields in the lookups of a qualified lookup field

Vertical bar (|)

●      Multiple display fields of a qualified lookup field (to distinguish from multiple nested display fields of any individual nested lookup fields)

Case

Delimiters

Example

Single record

Single-valued field

Multiple display fields

Comma separates multiple display fields

df1, df2

Single record

Multi-valued field

Single display field

Semi-colon separates multiple values

val1; val2

Single record

Multi-valued field

Multiple display fields

Semi-colon separates multiple values; comma separates multiple display fields

val1-df1, val1-df2;

val2-df1, val2-df2

Multiple records

Single-valued field

Single display field

Semi-colon separates multiple record values

rec1; rec2

Multiple records

Single-valued field

Multiple display fields

Semi-colon separates multiple record values; comma separates multiple display fields

rec1-df1, rec1-df2;

rec2-df1, rec2-df2

Multiple records

Multi-valued field

Single display field

Semi-colon separates multiple values of multiple records and multi-valued field

rec1-val1; rec1-val2; rec2-val1

Multiple records

Multi-valued field

Multiple display fields

Semi-colon separates multiple values; comma separates multiple display fields

rec1-val1-df1, rec1-val1-df2; rec1-val2-df1, rec1-val2-df2; rec2-val1-df1, rec2-val1-df2

Qualified lookup field

Vertical bar separates display fields

df1 | df2 | df3

Qualified lookup field

Nested display fields

Vertical bar separates display fields; comma separates nested display fields

df1 | df2-ndf1, df2-ndf2 | df3

Nested multi-valued field

Semi-colon separates nested multi-values; vertical bar separates display fields

df-val1-ndf1 | df-val1-ndf2 ; df-val2-ndf1 | df-val2-ndf2

Nested multi-valued field w/ multiple display fields

Comma separates nested display fields; semi-colon separates nested multi-values; vertical bar separates display fields

df1-val1-ndf1 | df1-val1-ndf2 ; df1-val2-ndf1 | df1-val2-ndf2 ,

df2-val1-ndf1 | df2-val1-ndf2 ; df2-val2-ndf1 | df2-val2-ndf2