Microsoft KB Archive/63527

Works: Converting a Multiple-Line Field into Separate Fields

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

2.00 3.00

MS-DOS

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

= SUMMARY =

You can convert each line of a multiple-line field from Form view into a separate field. However, there must be a newline character at the end of each line to be split (a newline character is created by pressing SHIFT+ENTER). If there are no hard line breaks, then the field must be edited before they can be split up. To split the lines into individual fields, do the following:


 * 1) From the File menu, choose Save As (ALT, F, A).
 * 2) Type a new name for the file (so that the original is not deleted), for example, TXT.WDB.
 * 3) Tab to the Format box and select Text & Commas.
 * 4) Press ENTER.
 * 5) From the File Menu, choose Open (ALT, F, O).
 * 6) Type in TXT.WDB (or whatever name you gave the file) and press ENTER.
 * 7) When prompted, choose to open the file as a Word Processor.
 * 8) From the Word Processor, choose Select Replace (ALT, S, R).
 * 9) In the “Search For” field, type “^25” (without the quotation marks). This searches for a new line character. (^N does not work in this situation.)
 * 10) Tab to the “Replace With” Field and type “,” (include the quotation marks). This replaces all newline characters with a comma surrounded by quotation marks. The comma and quotation marks delimit the record so that the individual fields are created.
 * 11) Tab to either Replace or Replace All and press ENTER. (Replace will ask you to confirm each replacement, Replace All will not.)
 * 12) From the File menu, choose Save As (ALT, F, A).
 * 13) Make sure the Format Box is set to “Text” and press ENTER.
 * 14) Close the file (ALT, F, C).
 * 15) Reopen the file (ALT, F, O and type in TXT.WDB or whatever the filename is).
 * 16) Press ENTER.
 * 17) Choose to Open the file as a Database file.

The lines have now been split up into individual fields.

Note: Multiple lines cannot be viewed in List view.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 3.00 =

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