home *** CD-ROM | disk | FTP | other *** search
/ Simtel MSDOS 1992 September / Simtel20_Sept92.cdr / msdos / lotus123 / 123train.arc / DATA.AST < prev    next >
Text File  |  1986-11-01  |  2KB  |  50 lines
  1. .op
  2.                    First Data File Assignment
  3.  
  4. Thi≤ assignmen⌠ wil∞ givσ yo⌡ somσ practicσ witΦ thσ 12│ datß ì
  5. file capability. 
  6.  
  7. Star⌠ witΦ thσ spreadshee⌠ calleΣ DATAONLY.WK1«  Usσ thσ EXTRAC╘ ì
  8. commnaΣ t∩ finΣ thσ house≤ witΦ morσ thaε threσ bedroom≤ tha⌠ arσ ì
  9. sellinτ fo≥ les≤ thaε $200,00░.
  10.  
  11. Your result should look like this:
  12.  
  13.  
  14.     HOUSES WITH MORE THAN THREE BEDROOMS FOR UNDER $200,000
  15.  
  16.     ADDRESS            BDRMS       AGE       COST
  17.  
  18.     95 Horne Pl            4        14    $65,000
  19.     203 Somerset Ave       4        12    $95,000
  20.     86 Howard St           4        16   $105,000
  21.     19 Hill Rd             4        26   $110,000
  22.     19 Auburn St           4        22   $112,500
  23.     1582 Central Ave       4         7   $125,000
  24.     14 Grimshaw            4        32   $135,000
  25.     2 Beech Ave            4        11   $175,000
  26.     46 Prospect Pl         5        22    $90,000
  27.     198 Upland Rd          5        27   $105,000
  28.     315 Fremont Ave        5        20   $160,000
  29.     16 Rice St             5        18   $180,000
  30.     714 Orchard St         5        15   $185,000
  31.     87 Newbury St          6        17   $120,000
  32.     1122 Bellevue          6         9   $140,000
  33.     34 Harley Pl           7        40   $180,000
  34.  
  35.  
  36. Notσ tha⌠ ╔ havσ no⌠ extracteΣ al∞ oµ thσ fields¼ jus⌠ fou≥ oµ ì
  37. them«  Thσ columε width≤ anΣ heading≤ arσ somewha⌠ differen⌠ thaε ì
  38. thσ origina∞ file¼ anΣ thσ selecteΣ record≤ havσ beeε sorteΣ int∩ ì
  39. ß differen⌠ order«  
  40.  
  41. Hint
  42.  
  43.      Placσ thσ criterioε anΣ outpu⌠ range≤ t∩ thσ righ⌠ oµ thσ ì
  44. ááááádatß file¼ likσ this:
  45.  
  46.  
  47.  
  48.  
  49.  
  50.