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. For example, Artist/Maker: Bill Culbert, Ralph Hotere, Role: Artist, Artist. •If the AMV flag is set to 1, values will be displayed by row. For example, Artist/Maker: Bill Culbert, Role: Artist, Artist/Maker: Ralph Hotere, Role: Artist. •If the AMV flag is set to 2, the first value for the first field will be displayed in front of every value for the second field. For example, Artist/Maker: Bill Culbert, Role: Artist, Artist/Maker: Bill Culbert, Role: Artist. •If the AMV flag is set to 4, delimiters are retained for missing fields. When MULTI.FIELDS is used in a symbolic to export structured data, the field separators are essential to retain alignment between fields across multiple rows of data.
|
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
