Change multi-value field delimiter in Legal Review Concordance load file production DAT file to alternate character

SYMPTOMS

When producing a Concordance collection in Legal Review that includes multiple email addresses in a multi-value field, such as 'emailto' or 'emailcc', each e-mail address is saved with a comma in the 'last name, first name' syntax of the user description for each e-mail address. This creates a situation that separates the data for each e-mail address entry into 2 values during a subsequent import since a comma is also used as a hard delimiter to separate each data value in multi-value field.

CAUSE

While the 'emailto' and 'emailcc' fields are multi-value, the data is separated by a hard-coded comma then subsequently treated as one field.

RESOLUTION

As a ] is placed at the end of each e-mail address with a comma directly following it to separate the multiple e-mail addresses, the .DAT file created during production can be opened in a text editor and global find/replace performed replacing the '],' string with '];' to only change the comma delimiters in the multi-value field to a semicolon. The end result will ensure that the individual email strings that include commas will be treated as individual data elements.

APPLIES TO

3.6