Microsoft KB Archive/66232

Works: Separating Contents of One Field into Many Fields

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

2.00 3.00

MS-DOS

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

= SUMMARY =

Works does not separate established fields. For example, there is no quick way to split the contents of a field called “NAME” into two fields called “FIRSTNAME” and “LASTNAME.”

= WORKAROUND =

A workaround is to save the database as text, edit it in the Word Processor, then re-open it as a database. However, this method erases all formatting information, such as underlining and form layout. To accomplish this workaround, do the following:


 * 1) While in the database file, from the File menu, choose Save As, and save the file with another name (for example, TEST). In the Format option box, select Text & Tabs, and press ENTER.
 * 2) Close the file. When the “Save changes?” message appears, select No.
 * 3) Open the new file (TEST) as a word processor document.
 * 4) Edit the file, putting tabs after every item that you want to be in a separate field.
 * 5) From the File menu, choose close, and save any changes to filename TEST.
 * 6) From the File menu, choose Open Existing File, and open it as a database.
 * 7) The new database will appear. The format will be different but the information will be in separate fields. The form may now be edited and the field names may be changed and rearranged.
 * 8) From the File menu, choose Save As to save the new database as a Works database. In the Format option box, select “Works.”

Reference(s):

“Microsoft Works Reference,” version 2.0, page 342

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: database fields 2.00 3.00 =

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