SYMPTOMS:
When importing a CSV file in Strategy Analytics Desktop 9.4.1.x, the semicolon separator is not recognized. For example, the CSV file below contains both colon and semicolon, as shown:
Sample Code/Error
1; teste1 2; teste2 3; teste3 4; teste4 5; teste5 6, teste6 7, teste7 8, teste8 9, teste9 10, teste10

CAUSE:
This is a known issue in Strategy Analytics Desktop 9.4.1.x.
ACTION:
Contact the Strategy Technical Support for an update on this issue.
WORKAROUND:
Use only colon as separator.
The Strategy Internal Reference Number for the issue discussed in this technical note is 503883.