Home » Archimedes archive » Acorn User » Acorn User - Updated Education disc (1994).adf » Database » !AddInfo
!AddInfo
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
| Tape/disk: | Home » Archimedes archive » Acorn User » Acorn User - Updated Education disc (1994).adf » Database |
| Filename: | !AddInfo |
| Read OK: | ✔ |
| File size: | 02D4 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
The file 'Address' is in CSV (comma separated value) format and as such, can be used with most database programs. A new datafile should first be created with the following fields in the order they appear here. The numbers in brackets represent the field length and the word indicates the type of data that will appear in the field: Name (30) Text Address (20) Text Nearest Town (15) Text Nearest City (15) Text County (15) Text Postcode ( 8) Text Telephone Number (15) Text If a fax number is also required, before loading the CSV file into the newly created datafile, add a comma at the end of each line.
00000000 54 68 65 20 66 69 6c 65 20 27 41 64 64 72 65 73 |The file 'Addres| 00000010 73 27 20 69 73 20 69 6e 20 43 53 56 20 28 63 6f |s' is in CSV (co| 00000020 6d 6d 61 20 73 65 70 61 72 61 74 65 64 20 76 61 |mma separated va| 00000030 6c 75 65 29 20 66 6f 72 6d 61 74 20 61 6e 64 20 |lue) format and | 00000040 61 73 0a 73 75 63 68 2c 20 63 61 6e 20 62 65 20 |as.such, can be | 00000050 75 73 65 64 20 77 69 74 68 20 6d 6f 73 74 20 64 |used with most d| 00000060 61 74 61 62 61 73 65 20 70 72 6f 67 72 61 6d 73 |atabase programs| 00000070 2e 20 41 20 6e 65 77 20 64 61 74 61 66 69 6c 65 |. A new datafile| 00000080 20 73 68 6f 75 6c 64 0a 66 69 72 73 74 20 62 65 | should.first be| 00000090 20 63 72 65 61 74 65 64 20 77 69 74 68 20 74 68 | created with th| 000000a0 65 20 66 6f 6c 6c 6f 77 69 6e 67 20 66 69 65 6c |e following fiel| 000000b0 64 73 20 69 6e 20 74 68 65 20 6f 72 64 65 72 20 |ds in the order | 000000c0 74 68 65 79 20 61 70 70 65 61 72 0a 68 65 72 65 |they appear.here| 000000d0 2e 20 54 68 65 20 6e 75 6d 62 65 72 73 20 69 6e |. The numbers in| 000000e0 20 62 72 61 63 6b 65 74 73 20 72 65 70 72 65 73 | brackets repres| 000000f0 65 6e 74 20 74 68 65 20 66 69 65 6c 64 20 6c 65 |ent the field le| 00000100 6e 67 74 68 20 61 6e 64 20 74 68 65 20 77 6f 72 |ngth and the wor| 00000110 64 0a 69 6e 64 69 63 61 74 65 73 20 74 68 65 20 |d.indicates the | 00000120 74 79 70 65 20 6f 66 20 64 61 74 61 20 74 68 61 |type of data tha| 00000130 74 20 77 69 6c 6c 20 61 70 70 65 61 72 20 69 6e |t will appear in| 00000140 20 74 68 65 20 66 69 65 6c 64 3a 0a 0a 4e 61 6d | the field:..Nam| 00000150 65 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |e | 00000160 20 20 20 20 20 20 20 28 33 30 29 20 20 54 65 78 | (30) Tex| 00000170 74 0a 41 64 64 72 65 73 73 20 20 20 20 20 20 20 |t.Address | 00000180 20 20 20 20 20 20 20 20 20 20 20 20 28 32 30 29 | (20)| 00000190 20 20 54 65 78 74 0a 4e 65 61 72 65 73 74 20 54 | Text.Nearest T| 000001a0 6f 77 6e 20 20 20 20 20 20 20 20 20 20 20 20 20 |own | 000001b0 20 28 31 35 29 20 20 54 65 78 74 0a 4e 65 61 72 | (15) Text.Near| 000001c0 65 73 74 20 43 69 74 79 20 20 20 20 20 20 20 20 |est City | 000001d0 20 20 20 20 20 20 28 31 35 29 20 20 54 65 78 74 | (15) Text| 000001e0 0a 43 6f 75 6e 74 79 20 20 20 20 20 20 20 20 20 |.County | 000001f0 20 20 20 20 20 20 20 20 20 20 20 28 31 35 29 20 | (15) | 00000200 20 54 65 78 74 0a 50 6f 73 74 63 6f 64 65 20 20 | Text.Postcode | 00000210 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000220 28 20 38 29 20 20 54 65 78 74 0a 54 65 6c 65 70 |( 8) Text.Telep| 00000230 68 6f 6e 65 20 4e 75 6d 62 65 72 20 20 20 20 20 |hone Number | 00000240 20 20 20 20 20 28 31 35 29 20 20 54 65 78 74 0a | (15) Text.| 00000250 0a 49 66 20 61 20 66 61 78 20 6e 75 6d 62 65 72 |.If a fax number| 00000260 20 69 73 20 61 6c 73 6f 20 72 65 71 75 69 72 65 | is also require| 00000270 64 2c 20 62 65 66 6f 72 65 20 6c 6f 61 64 69 6e |d, before loadin| 00000280 67 20 74 68 65 20 43 53 56 20 66 69 6c 65 20 69 |g the CSV file i| 00000290 6e 74 6f 20 74 68 65 0a 6e 65 77 6c 79 20 63 72 |nto the.newly cr| 000002a0 65 61 74 65 64 20 64 61 74 61 66 69 6c 65 2c 20 |eated datafile, | 000002b0 61 64 64 20 61 20 63 6f 6d 6d 61 20 61 74 20 74 |add a comma at t| 000002c0 68 65 20 65 6e 64 20 6f 66 20 65 61 63 68 20 6c |he end of each l| 000002d0 69 6e 65 2e |ine.| 000002d4
.