Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive : DB2WP.ZIP
Filename : DB2WP.WPF
Output of file : DB2WP.WPF contained in archive : DB2WP.ZIP
ûÿ 2 B ÿÿV ^ ´ ÿÿW 6 #| x Schoolbook 10 Pt. ÿÿÿ * \ , , , ô¯Xô\ Ìl P P" ®B þþþþþþþþþÿÿÿÿÿÿþÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ " ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ^,,4X,<
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì Ð #| x GLYPHIX2 GLYP.PRS Xx t¤ @É ÉS ,,,,0.xWÒT I. A. 1. a.(1)(a) i) a) 1. a. i.(1)(a)(i) 1) a) T ÒÐÌ X°` ¸ hÀpÈ x Ð (#%Ø'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì Ðûÿ 2 × â ¢ e v é x _ " ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ^ H H X Ì Ì È H h h Ø H H H H H Ø Ø Ø X ¨ ° Ä Ä Ì X X ¨ Ø À Ì Ì ¸ ä ¬ h h H | x L H D H Ü h l T x Ä t t Ø Courier 12 Pt. (internal) Garamond 16 Pt. Courier 14 Pt. àCourier 12 Pt. ÿCourier 12 Pt. Italic ,Head1 Heading Level 1 = «X à Ãà Ã× ×× ×Ä ÄÄ ÄHead2 g1 Heading Level 2 ~ @ ÃÃà Ã× ×× ×
ÄÄÄ Äûÿ 2 Á p ø y ( q (
Head4 Heading Level 4 {_ # ÃÃ× ×× ×ÄÄCol02BP BP Two even block-protected parallel columns Ð 5é qÜÊ ÒÆ °À(# Æ ÒÅ ¸ ÅŸ ÅÒÆ °À(# °À(# Æ ÒTabBul12 Tabs for bullets at 12 cpi s Ð }Ú ÐÌ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ,X°Ü4`
¸ ä <hÀìDpÈô L x ¤ Ð ü!(#ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì ÐTabNum12 Tabs for numbers at 12 cpi i Ð «Á ÐÌ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ¤0¼H Ô
` ì
x ¨4ÀLØd ð | "ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì Ðûÿ 2 ( ó (
° C
ó TabBul10 Tabs for bullets at 10 cpi Ð }Ú ÐÌ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ,X°Ü4`
¸ ä <hÀìDpÈô L x ¤ Ð ü!(#ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì ÐTabNum10 Tabs for numbers at 10 cpi Ð { ÐÌ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ $°<Ô` ì
4ÀLäpü ¬ D Ð \"ô#% 'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì ÐOutlPara Para # def for std outline scheme X ÒT 1. a. i.(1)(a)(i) 1) a) I. A. 1. a.(1)(a)[1][a] T ÒCol02News Two newspaper style columns, with tabs
·{ 7tÒÆ °8 (# Æ ÒÐÌ X°` ¸ hÀpÈ x Ð (#%Ø'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ X°Ü4`
¸ ä <hÀ Ìø$P|¨Ô , X !°"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì ÐÒÆ °8 (# °8 (# Æ ÒÐÌ X°Ü4`
¸ ä <hÀ Ìø$P|¨Ô , X !°"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ X°Ü4`
¸ ä <hÀ Ìø$P|¨Ô , X !°"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì Ðûÿ 2 v ³ ® ) ÿÿ J × Head3 Heading Level 3 ¾ «Y ÃÃà Ã× ×× ×ÄÄÄ Ää-ÿÿ¦ , x x x , XXx t¤ @É ÉS þþþþþþÿÿÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ´Ö ? H H , = Ð P P Ï þþþþþþþÿþÿÿÿÿÿÿþÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿh.ÿÿÁ 2 , , ¼¼ t¤ @É ÉÏó þþþþþþþþþÿÿÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¢-ÿÿ¦ , x x x , = XùXx t¤ @É IÎó þþþþþþþÿþÿÿÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ&.ÿÿ¦ , x x x , N XÙXx t¤Ü HÉ S þþþþþþþÿÿÿÿÿÿÿÿþÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Õã ´ ,ýÚy x °° d d d y ÚÔ
Ô
DB2WP.WPM DocumentationÁà! ì( Á© ©Á`- (#9 ÁSeptember 16, 1988ã ÕÃÃÛ {TabNum10 ÛÐÌ X°Ðð0 P
p °
Ðð0Pp°Ðð0P p ° Ð ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ $°<Ô` ì
4ÀLäpü ¬ D Ð \"ô#% 'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ Ì ÐÛ ÛdBase III+ Delimited File to WordPerfect 5.0 Merge Format
ÄÄ
à ÃÄ ÄCopyright (c) 1988, Stuart Bloom
à ÃÄ ÄPermission is granted to distribute this macro and its
accompanying documentation on a FREE basis only. No fee may be
charged for copying, shipping, or transmission without the
author's written consent. Permission is specifically granted to
distribute this macro through on©line data base services.
à ÃÄ ÄThe user assumes all risks associated with the use of this macro
and by using it agrees to this assumption.
ÒT 1. a. i.(1)(a)(i) 1) a) 1. a.(1)(a)[1][a] 1) a) T ÒThis macro, Ã ÃDB2WP.WPMÄ Ä, does two things:
Ø 1. ØÂ <
ÂConverts a dBase III format delimited file into
WordPerfect 5.0 merge format.Æ(#<Æ
Â
<
ÂA dBase III format file is a "comma©delimited ASCII" file.
All fields are separated by commas. Fields defined as
Character fields within dBase are enclosed in quotes.
Numeric fields, logical fields, and date fields are ÃÃnotÄÄ
enclosed in quotes. Commas may be present within character
fields, but not in any other type of field.Æ(#<Æ
Â
<
ÂThis macro should work with most comma©delimited ASCII files,
with or without quotes, provided that ÃÃno commas appear in
unquoted fieldsÄÄ; it has been tested, however, ÃÃonlyÄÄ with
dBase III+ delimited files.Æ(#<Æ
Ø 2. ØÂ <
ÂOnce a file has been converted into WordPerfect merge format,
allows the user to convert dates in dBase III export format
to a more standard form.Æ(#<Æ
Â
<
ÂdBase III exports date fields in this format:Æ(#<Æ
Á
<
ÁÁ
Ô ÁYYYYMMDDÂ Ô ÂÂ Âwhere:Â $$ 4$ ÂÂ $ À( ÂYYYY is the yearÆ(#ÀÆ
Á
<
ÁÁ
Ô ÁÁ ` ÁÁ ì
ÁÁ ÁÁ ÁÁ ! ÁÁ ! 4$ ÁÂ $ À( ÂMM is the monthÆ(#ÀÆ
Á
<
ÁÁ
Ô ÁÁ ` ÁÁ ì
ÁÁ ÁÁ ÁÁ ! ÁÁ ! 4$ ÁÂ $ À( ÂDD is the dayÆ(#ÀÆ
Á
<
ÁJune 11, 1989, for example, would be represented à Ã19890611Ä Ä.
Ô # ÔÅ £ÅÂ
<
ÂThis is ideal for sorting, but not for human comprehension.
This macro, therefore, allows the conversion of this format
into any of these four formats:Æ(#<Æ
Á
<
ÁÁ
Ô ÁMM©DD©YYÂ Ô ÂÂ Â06©11©89Æ(#Æ
Á
<
ÁÁ
Ô ÁMM/DD/YYÁ ÁÁ Á06/11/89
Á
<
ÁÁ
Ô ÁMM©DD©YYYYÁ Á06©11©1989
Á
<
ÁÁ
Ô ÁMM/DD/YYYYÁ Á06/11/1989
ÃÃPreparing the File ÒT 1. a.(1)(a)[1][a] 1) a) 1. a.(1)(a)[1][a] 1) a) T ÒIn dBase III+ÄÄ:Ô
Á 2
Ô
In dBase III+, the basic strategy is to use the à ÃCOPY TO DELIMITEDÄ Ä
feature to export a comma©delimited ASCII file. The steps are:
Ø 1. ØÂ <
ÂMake the file from which records are to be written the active
file using a command like:Æ(#<Æ
Á
<
ÁÁ
Ô ÁÃ ÃUSE
Â
<
ÂThe à ÃINDEX
records in the dBase III+ file will be exported in the order
specified by the index.Æ(#<Æ
Å£ÅØ 2. Ø <
ÂWrite the desired records to a text file using the dBase III+
command:Æ(#<Æ
Á
<
ÁÂ $
Ô ÂÃ ÃCOPY TO
[FOR
Â
<
ÂThe minimum syntax is à ÃCOPY TO
fields are specified, they will be exported in the order they
are named. If conditions are specified, those conditions
will govern which records are exported.Æ(#<Æ
Â
<
Â(See the dBase III+ manual for additional options with the
à ÃCOPY TOÄ Ä command.)Æ(#<Æ
Â
<
ÂNote that if no file extension is specified, dBase III+ will
automatically append the .TXT extension.Æ(#<Æ
ÃÃÔ Ã! ÔÅ o ÅRunning the Macro In WordPerfectÄÄÔ
Á 2
Ô
In WordPerfect:
ÒT 1. a.(1)(a)[1][a] 1) a) 1. a.(1)(a)[1][a] 1) a) T ÒØ 1. ØÂ <
ÂRetrieve the file to be converted. If the file is still a
text file (which it will be until it has been retrieved into
WordPerfect and saved), use the sequence:Æ(#<Æ
Á
<
ÁÁ
Ô ÁÃ ÃCtrl©F5 T R
Â
<
ÂOnce the file has been saved in WordPerfect format one time,
it can be retrieved in the standard manner using à ÃShft©F10Ä Ä or
from the à Ã[List Files]Ä Ä screen.Æ(#<Æ
Åo ÅØ 2. ØÂ <
ÂStart the macro à ÃDB2WPÄ Ä.Æ(#<Æ
Â
<
ÂÃ ÃNOTE:Ä ÄÂ $ ` ÂÃ Ã[Cancel]Ä Ä will stop the macro at any point.Æ(#` Æ
Å 4ÅØ 3. ØÂ <
ÂThe first choice will be to:Æ(#<Æ
Á
<
Á1 Convert dBase III file to WP Merge
Á
<
Á2 Change Date fields
Á
<
Á0 Quit
Â
<
ÂYou must convert the file (choice 1) before you can change
the date fields.Æ(#<Æ
Å4ÅØ 4. ØÂ <
ÂTo convert the dBase file to WP Merge format:Æ(#<Æ
Á
<
ÁØ a. Ø $ Ô ÂSelect à ÃCÄ Äonvert dBase III file to WP Merge (à Ã1Ä Ä)Æ(#ÔÆ
Á
<
ÁØ b. ØÂ $ Ô ÂYou will see a message asking you to confirm that the
correct file is displayed on the screen.Æ(#ÔÆ
Á
<
ÁÁ
Ô ÁØ (1) ØÂ ° ` ÂIf it is, answer "Y." The macro will do the
conversion. If you have a large file and/or a slow
computer, this will take awhile, so be patient.Æ(#` Æ
Á
<
ÁÁ
Ô ÁØ (2) ØÂ ° ` ÂIf it is not, answer "N." A message will appear
instructing you to retrieve the file and re©run the
macro. The macro will then terminate.Æ(#` Æ
Ô Ã! ÔÅ | ÅØ 5. ØÂ <
ÂTo convert dBase III date formats to a more standard format:Æ(#<Æ
Á
<
ÁØ a. Ø $ Ô ÂSelect Change à ÃDÄ Äate fields (à Ã2Ä Ä)Æ(#ÔÆ
Á
<
ÁØ b. ØÂ $ Ô ÂYou will see a message asking you to confirm that the
correct file is displayed on the screen.Æ(#ÔÆ
Á
<
ÁÁ
Ô ÁØ (1) ØÂ ° ` ÂIf it is, answer "Y."Æ(#` Æ
Á
<
ÁÁ
Ô ÁØ (2) ØÂ ° ` ÂIf it is not, answer "N." A message will appear
instructing you to retrieve the file and re©run the
macro. The macro will then terminate.Æ(#` Æ
Å| ÅÁ
<
ÁØ c. ØÂ $ Ô ÂAssuming you have answered "Y" to the previous query, the
macro will next ask you to select your delimiter. This is
the character that will separate the month, day, and year.
You have two choices:Æ(#ÔÆ
Á
<
ÁÁ
Ô ÁØ (1) ØÂ ° ` ÂA slash (Ã Ã/Ä Ä)Æ(#` Æ
Á
<
ÁÁ
Ô ÁØ (2) ØÂ ° ` ÂA dash (Ã Ã-Ä Ä)Æ(#` Æ
Å ÅÁ
<
ÁØ d. ØÂ $ Ô ÂYou are next asked to select the format in which the year
will be displayed. There are two choices:Æ(#ÔÆ
Á
<
ÁÁ
Ô ÁØ (1) ØÂ ° ` ÂÃ Ã2Ä Ä©digit format (e.g., 88)Æ(#` Æ
Á
<
ÁÁ
Ô ÁØ (2) ØÂ ° ` ÂÃ Ã4Ä Ä©digit format (e.g., 1988)Æ(#` Æ
ÅÅÁ
<
ÁØ e. ØÂ $ Ô ÂYou are then asked for the field number to convert.Æ(#ÔÆ
Â
<
ÂÂ
Ô ÂFields are numbered beginning with the first field in each
record. If, for example, the first field - i.e., the
first line of text ending with ^R © is a date field, and
you want to convert it, type à Ã1Ä Ä, then press à Ã[Enter]Ä Ä. The
macro will then convert the first field in every record
into your chosen format.Æ(#ÔÆ
Â
<
ÂÂ
Ô ÂÃ ÃCAUTION:Ä ÄÂ ° ÂThis macro does next to no error checking. If
you select a field that is ÃÃnotÄÄ a dBase III date
field, the results will be unpredictable,
interesting, and most undesirable. Also, if you
only have 8 fields and you tell the macro to
convert field 11, strange and unpleasant things
will happen.Æ(# Æ
Ô ê$ ÔÅ ÅÁ
<
ÁØ f. ØÂ $ Ô ÂAfter the macro has finished, it will ask you for another
field number. You can continue this until you have
converted all the dBase III date field you want to
convert.Æ(#ÔÆ
ÅÅ
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/