Microsoft KB Archive/31274

Problem Importing Files with More than One Delimiter PSS ID Number: Q31274 Article last modified on 01-18-1989 PSS database name: D_MPlan

3.x 4.00

MS-DOS

Summary:

Make sure the ASCII files that you import using the Transfer Import command do not contain spaces between the delimiter and the value. If there is a space between the delimiter and the number, the field is interpreted as text.

For example, if the text file is of the following form, the information comes across as numbers:

1,2,3 4,5,6

However, if the file is of the following form and you specify a comma as the delimiter, the 3 and the 5 come into Multiplan as their text equivalents (“3” and “5”) instead of as the numbers 3 and 5 due to the space preceding them. (This problem also occurs with trailing spaces.)

1,2, 3 4, 5,6

If the values are to appear as numbers instead of text, the text file has to be edited in a word processor so that it contains no extra spaces between the numbers and the delimiters.

Copyright Microsoft Corporation 1989.