Defining a Delimiter

Use this view to select the appropriate delimiter value for your list and preview records before you import them to Infor CRM. A delimiter parses fields in a list. Infor CRM analyzes the list to determine which delimiter is currently used, but you can select a different delimiter if necessary.

To define a delimiter and preview

When importing leads, after selecting a file, click Next.
If you need to change the delimiter, click one of the following options:
- Tab
- Semicolon
- Comma
- Space
- Other
If you selected Other, you must specify the delimiter used to separate fields in the list. Specify the delimiter character in the Other field.
From the Text Qualifier list, click the drop-down arrow and select a qualifier from the list. A text qualifier identifies text that must be imported exactly as the same must be displayed.
If the list contains field names, select the First Row Contains Field Names check box to display the field names in the Preview area.

Note: If there are extended characters in the imported file that do not correctly display in the Preview area, you must save the import file again and explicitly define the encoding type as UTF-8, Unicode, or ANSI. After you save the file again, click Back to return to the Select a File step and reselect the updated file before you continue the import.
Click Next to go to the next step.