We have five characters that can denote separation between values for a User Defined Field- an asterisk (*), a vertical line (|), a comma (,), a semi colon (;), or a tilde (~). When we type the values in our CSV file, we will separate the values using one of these characters. We must use the same character for the entire CSV file. We also, will not use any spaces between the values. For example, if we are importing favorite colors and the constituent's favorite colors are Red, Blue, and Green, we would type one of the following lines into the CSV file:
  • Red*Blue*Green
  • Red|Blue|Green
  • Red,Blue,Green
  • Red;Blue;Green
  • Red~Blue~Green