Microsoft KB Archive/61108

Works: Importing Comma- and Tab-Delimited Files

PSS ID Number: Q61108 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SUMMARY =

Works 2.0 and 3.0 do not correctly import a comma- or tab-delimited text file into a spreadsheet or database if there are both commas and tabs in the text file. If both are present, Works recognizes the tab as the primary delimiter; any commas in the text file are included in the cell.

For example, the following text entry

Bill,Steve,Jim,45 Tony,Kevin

which has both tabs and commas, imports into the Spreadsheet as follows:

Column A Column B Bill,Steve,Jim,45 Tony,Kevin

This problem does not occur with Works 1.x where both tabs and commas are recognized as delimiters and the values are placed in their proper cells.

= MORE INFORMATION =

To correct this problem, do the following:


 * 1) Open the text file that is being imported into a Works Word Processor document.
 * 2) Press CTRL+HOME (this procedure takes you to the top of the document).
 * 3) Go to the Select menu and choose Replace (ALT+S R).
 * 4) In the “Search For:” field, type a comma.
 * 5) In the “Replace with:” field, type ^t (replacing commas with tabs).
 * 6) Tab down to either Replace or Replace All and press ENTER (Replace allows you to confirm every change, Replace All replaces all occurrences automatically).
 * 7) Save the file, highlight all the text, and then select Copy from the Edit menu (ALT+E C).
 * 8) Open a spreadsheet or database file and press ENTER. This procedure copies the text from the Word Processor file into a spreadsheet or database file in “tab delimited” format.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 3.00 =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.