Previous Topic: Create a Member List from a CSV FileNext Topic: RACI Operations


Special Characters for Member Lists

The following system properties define special characters that are used to parse comma-separated values (CSV) files for member lists.

memberlist.csv.reader.separator

Defines the character that separates fields in each line of the file. The comma (,) character is used by default.

memberlist.csv.reader.quotechar

Defines the character that encloses field values that have spaces of other special characters. The double-quote (") character is used by default.

memberlist.csv.reader.escape

Defines the escape sequence that is used in the file. The backslash (\) character is used by default.

Example: Backslash Characters in CSV Input

Often CSV input for a member list contains backslash characters in pathnames, as in the following example:

Login, Category, Value
DOMAIN\Hector_Torres, ResName3, Solaris\HTorres
DOMAIN\Alex_Patrick, Location, Atlanta

By default, the CSV parser treats the backslash character as an escape character. The resulting member list omits backslashes, as follows:

Login, Category, Value
DOMAINHector_Torres, ResName3, SolarisHTorres
DOMAINAlex_Patrick, Location, Atlanta

To include the backslash character in field values, edit the memberlist.csv.reader.escape system property to define a different escape character.

Note: Select an escape character that does not appear in your data. Do not use the double quote character as an escape character.