Purpose/Function
Allows you to join two (or more) fields together.
Argument syntax and parameters
MULTI.FIELDS!arg2!arg3!arg4!arg5!arg6
arg2 |
Required |
Internal field names of fields to be concatenated, delimited by ';' e.g. PROD_PRI_PERSON;PROD_PRI_ROLE.
|
arg3 |
Required |
Delimiter to be used between fields. This can be just a space or 'CR/LF' (Carriage Return Line Feed) to start each field on a new line.
|
arg4 |
Optional |
Delimiter to be used between values, if one or more of the fields is multi-valued.
|
arg5 |
Optional |
AMV flag for associated multi-value fields, i.e. fields that appear together in the same table, such as Artist/Maker and Role.
If no AMV flag is specified, values will be listed by column, e.g. Artist/Maker: Bill Culbert, Ralph Hotere, Role: Artist, Artist. If AMV flag set to 1, values will be displayed by row, e.g. Artist/Maker: Bill Culbert, Role: Artist, Artist/Maker: Ralph Hotere, Role: Artist. If AMV flag set to 2, the first value for field one will be displayed in front of every value for field two, e.g. Artist/Maker: Bill Culbert, Role: Artist, Artist/Maker: Bill Culbert, Role: Artist.
|
arg6 |
Optional |
Prefix text for each field, delimited by ';' For example, 'Artist/Maker: ;Role: '.
|
Parts of argument delimited by an exclamation mark.
Example:
MULTI.FIELDS!PROD_PRI_PERSON;PROD_PRI_ROLE!, !, !1
To join the Artist/Maker and Role fields as one. The delimiter between both fields and values is a comma and a space. The AMV flag is set to one, meaning terms will be displayed by row (from left to right, row by row).
For example: Bill Culbert, Artist, Ralph Hotere, Artist
