home *** CD-ROM | disk | FTP | other *** search
/ Simtel MSDOS 1992 December / simtel1292_SIMTEL_1292_Walnut_Creek.iso / msdos / lotus123 / 123train.arc / DATAEXT.AST < prev    next >
Text File  |  1988-05-05  |  2KB  |  55 lines
  1. .op
  2. .lq
  3.                    Datß Extractioε Assignment
  4.  
  5. Filσ managemen⌠ program≤ allo≈ yo⌡ t∩ extrac⌠ informatioε froφ ß ì
  6. file¼ creatinτ ß new¼ smalle≥ file«  Yo⌡ caε selec⌠ onl∙ record≤ ì
  7. whicΦ satisf∙ somσ searcΦ criterion«  Yo⌡ caε als∩ specif∙ thσ ì
  8. field≤ yo⌡ wisΦ includeΣ iε thσ ne≈ file«  Thesσ operation≤ arσ ì
  9. calleΣ "selectionó anΣ "projectionó respectively.
  10.  
  11. Star⌠ witΦ ß cop∙ oµ DATAONLY.WK1«  Usσ thσ EXTRAC╘ command t∩ ì
  12. finΣ thσ house≤ witΦ morσ thaε threσ bedroom≤ tha⌠ arσ sellinτ ì
  13. fo≥ les≤ thaε $200,000«  Prin⌠ the resul⌠ anΣ turε i⌠ in.
  14.  
  15. Thσ fina∞ repor⌠ shoulΣ look like this:
  16.  
  17.  
  18.     HOUSES WITH MORE THAN THREE BEDROOMS FOR UNDER $200,000
  19.  
  20.     ADDRESS            BDRMS       AGE       COST
  21.  
  22.     95 Horne Pl            4        14    $65,000
  23.     203 Somerset Ave       4        12    $95,000
  24.     86 Howard St           4        16   $105,000
  25.     19 Hill Rd             4        26   $110,000
  26.     19 Auburn St           4        22   $112,500
  27.     1582 Central Ave       4         7   $125,000
  28.     14 Grimshaw            4        32   $135,000
  29.     2 Beech Ave            4        11   $175,000
  30.     46 Prospect Pl         5        22    $90,000
  31.     198 Upland Rd          5        27   $105,000
  32.     315 Fremont Ave        5        20   $160,000
  33.     16 Rice St             5        18   $180,000
  34.     714 Orchard St         5        15   $185,000
  35.     87 Newbury St          6        17   $120,000
  36.     1122 Bellevue          6         9   $140,000
  37.     34 Harley Pl           7        40   $180,000
  38.  
  39.  
  40. Notσ tha⌠ ╔ havσ no⌠ extracteΣ al∞ oµ thσ fields¼ jus⌠ fou≥ oµ ì
  41. them«  Thσ columε width≤ anΣ heading≤ arσ als∩ differen⌠ thaε thσ ì
  42. origina∞ file¼ thσ selecteΣ record≤ havσ beeε sorteΣ int∩ ß ì
  43. differen⌠ order¼ anΣ ß headinτ ha≤ beeε addeΣ t∩ thσ report.
  44.  
  45.  
  46.  
  47.  
  48.  
  49. Hint: Placσ thσ criterioε anΣ outpu⌠ range≤ t∩ thσ righ⌠ oµ thσ ì
  50. áááááádatß file.
  51.  
  52. P. S. Thσ extraction¼ sortinτ anΣ printinτ coulΣ bσ automateΣ ì
  53. ááááááwitΦ ß macro.
  54.  
  55.