Home » Archimedes archive » Acorn User » AU 1997-04 A.adf » Features1 » StarInfo/Goodliffe/Docs/CsvMan_txt
StarInfo/Goodliffe/Docs/CsvMan_txt
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 » AU 1997-04 A.adf » Features1 |
| Filename: | StarInfo/Goodliffe/Docs/CsvMan_txt |
| Read OK: | ✔ |
| File size: | 0B02 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
Duplicates
There is 1 duplicate copy of this file in the archive:
- Archimedes archive » Acorn User » AU 1997-04 A.adf » Features1 » StarInfo/Goodliffe/!CsvEdit/Manual
- Archimedes archive » Acorn User » AU 1997-04 A.adf » Features1 » StarInfo/Goodliffe/Docs/CsvMan_txt
File contents
++------------------------+ || CsvEdit | || Pete Goodliffe | ++------------------------+ || Manual | ++------------------------+ INTRODUCTION CsvEdit is an editor for CSV files. Its operation is based upon the basic use of a spreadsheet, and anyone familiar with such programs will instantly be able to use it. It is supplied with GraphPlus, a graph processor. A CSV file is a universally recognised file structure for communicating data held in spreadsheet or table (and even database) form. It can describe such a structure of unlimited size, however CsvEdit can only handle a grid size of seven cells by twenty cells. CsvEdit fully supports interactive help. LOADING A CSV FILE To load a CSV file either drag it onto the CsvEdit icon on the iconbar or drag it into the editor window. If the CSV data spills outside of the available editing scope, a warning message will be shown. EDITING THE CSV FILE To open the editor window if it is not already open, click Select on the CsvEdit iconbar icon. The editor window comprises of the main work area, showing each of the cells in a seven by twenty grid. Below this is a tool pane with several buttons, a box showing the coordinates of the currently selected cell and a data entry area. Clicking on any cell with Select will select it, clicking on the selected cell with adjust will remove the selection. Once a cell is selected it is highlighted, and its data is shown in the data entry icon. Cursor keys will move to a different selected cell. To alter the cell, type any new text to come after the current text, or click in the data entry icon. CsvEdit allows you to insert and delete columns and rows. Move the selected cell to the row or column in question and choose the relevant entry from the menu. For easier use, two buttons are provided on the toolbar to do this task. Clicking on the columns icon with Select inserts a column, clicking on it with Adjust removes a column. The operation of the rows button is similar. The delete all main menu entry will wipe all the current data. If the file has been modified, CsvEdit asks for confirmation of this operation. SAVING THE CSVFILE The save dialogue box from the main menu allows you to do this in the normal Risc Os manner. Alternatively, click on the save toolbar icon. This has the same effect as clicking on the Save menu entry; it opens a save dialogue box if this is a new file, or saves it back where it was loaded from if not. CSVEDIT'S USE WITH GRAPHPLUS For users of GraphPlus, note that the CSV file cannot be dragged straight into the graph processor but must be saved to a physical file and then shown to GraphPlus. Please note that there is one as yet unused button on the toolbar. This will be used in possible future versions of CsvEdit.
00000000 2b 2b 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |++--------------| 00000010 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2b 0a 7c 7c 20 20 |----------+.|| | 00000020 20 20 20 20 20 20 43 73 76 45 64 69 74 20 20 20 | CsvEdit | 00000030 20 20 20 20 20 20 7c 0a 7c 7c 20 20 20 20 20 50 | |.|| P| 00000040 65 74 65 20 47 6f 6f 64 6c 69 66 66 65 20 20 20 |ete Goodliffe | 00000050 20 20 7c 0a 2b 2b 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d | |.++----------| 00000060 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2b 0a |--------------+.| 00000070 7c 7c 20 20 20 20 20 20 20 20 4d 61 6e 75 61 6c ||| Manual| 00000080 20 20 20 20 20 20 20 20 20 20 7c 0a 2b 2b 2d 2d | |.++--| 00000090 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 000000a0 2d 2d 2d 2d 2d 2d 2b 0a 0a 49 4e 54 52 4f 44 55 |------+..INTRODU| 000000b0 43 54 49 4f 4e 0a 0a 43 73 76 45 64 69 74 20 69 |CTION..CsvEdit i| 000000c0 73 20 61 6e 20 65 64 69 74 6f 72 20 66 6f 72 20 |s an editor for | 000000d0 43 53 56 20 66 69 6c 65 73 2e 20 49 74 73 20 6f |CSV files. Its o| 000000e0 70 65 72 61 74 69 6f 6e 20 69 73 20 62 61 73 65 |peration is base| 000000f0 64 20 75 70 6f 6e 20 74 68 65 0a 62 61 73 69 63 |d upon the.basic| 00000100 20 75 73 65 20 6f 66 20 61 20 73 70 72 65 61 64 | use of a spread| 00000110 73 68 65 65 74 2c 20 61 6e 64 20 61 6e 79 6f 6e |sheet, and anyon| 00000120 65 20 66 61 6d 69 6c 69 61 72 20 77 69 74 68 20 |e familiar with | 00000130 73 75 63 68 20 70 72 6f 67 72 61 6d 73 0a 77 69 |such programs.wi| 00000140 6c 6c 20 69 6e 73 74 61 6e 74 6c 79 20 62 65 20 |ll instantly be | 00000150 61 62 6c 65 20 74 6f 20 75 73 65 20 69 74 2e 0a |able to use it..| 00000160 0a 49 74 20 69 73 20 73 75 70 70 6c 69 65 64 20 |.It is supplied | 00000170 77 69 74 68 20 47 72 61 70 68 50 6c 75 73 2c 20 |with GraphPlus, | 00000180 61 20 67 72 61 70 68 20 70 72 6f 63 65 73 73 6f |a graph processo| 00000190 72 2e 0a 0a 41 20 43 53 56 20 66 69 6c 65 20 69 |r...A CSV file i| 000001a0 73 20 61 20 75 6e 69 76 65 72 73 61 6c 6c 79 20 |s a universally | 000001b0 72 65 63 6f 67 6e 69 73 65 64 20 66 69 6c 65 20 |recognised file | 000001c0 73 74 72 75 63 74 75 72 65 20 66 6f 72 0a 63 6f |structure for.co| 000001d0 6d 6d 75 6e 69 63 61 74 69 6e 67 20 64 61 74 61 |mmunicating data| 000001e0 20 68 65 6c 64 20 69 6e 20 73 70 72 65 61 64 73 | held in spreads| 000001f0 68 65 65 74 20 6f 72 20 74 61 62 6c 65 20 28 61 |heet or table (a| 00000200 6e 64 20 65 76 65 6e 20 64 61 74 61 62 61 73 65 |nd even database| 00000210 29 0a 66 6f 72 6d 2e 20 49 74 20 63 61 6e 20 64 |).form. It can d| 00000220 65 73 63 72 69 62 65 20 73 75 63 68 20 61 20 73 |escribe such a s| 00000230 74 72 75 63 74 75 72 65 20 6f 66 20 75 6e 6c 69 |tructure of unli| 00000240 6d 69 74 65 64 20 73 69 7a 65 2c 20 68 6f 77 65 |mited size, howe| 00000250 76 65 72 0a 43 73 76 45 64 69 74 20 63 61 6e 20 |ver.CsvEdit can | 00000260 6f 6e 6c 79 20 68 61 6e 64 6c 65 20 61 20 67 72 |only handle a gr| 00000270 69 64 20 73 69 7a 65 20 6f 66 20 73 65 76 65 6e |id size of seven| 00000280 20 63 65 6c 6c 73 20 62 79 20 74 77 65 6e 74 79 | cells by twenty| 00000290 20 63 65 6c 6c 73 2e 0a 0a 43 73 76 45 64 69 74 | cells...CsvEdit| 000002a0 20 66 75 6c 6c 79 20 73 75 70 70 6f 72 74 73 20 | fully supports | 000002b0 69 6e 74 65 72 61 63 74 69 76 65 20 68 65 6c 70 |interactive help| 000002c0 2e 0a 0a 4c 4f 41 44 49 4e 47 20 41 20 43 53 56 |...LOADING A CSV| 000002d0 20 46 49 4c 45 0a 0a 54 6f 20 6c 6f 61 64 20 61 | FILE..To load a| 000002e0 20 43 53 56 20 66 69 6c 65 20 65 69 74 68 65 72 | CSV file either| 000002f0 20 64 72 61 67 20 69 74 20 6f 6e 74 6f 20 74 68 | drag it onto th| 00000300 65 20 43 73 76 45 64 69 74 20 69 63 6f 6e 20 6f |e CsvEdit icon o| 00000310 6e 20 74 68 65 20 69 63 6f 6e 62 61 72 0a 6f 72 |n the iconbar.or| 00000320 20 64 72 61 67 20 69 74 20 69 6e 74 6f 20 74 68 | drag it into th| 00000330 65 20 65 64 69 74 6f 72 20 77 69 6e 64 6f 77 2e |e editor window.| 00000340 0a 0a 49 66 20 74 68 65 20 43 53 56 20 64 61 74 |..If the CSV dat| 00000350 61 20 73 70 69 6c 6c 73 20 6f 75 74 73 69 64 65 |a spills outside| 00000360 20 6f 66 20 74 68 65 20 61 76 61 69 6c 61 62 6c | of the availabl| 00000370 65 20 65 64 69 74 69 6e 67 20 73 63 6f 70 65 2c |e editing scope,| 00000380 20 61 0a 77 61 72 6e 69 6e 67 20 6d 65 73 73 61 | a.warning messa| 00000390 67 65 20 77 69 6c 6c 20 62 65 20 73 68 6f 77 6e |ge will be shown| 000003a0 2e 0a 0a 45 44 49 54 49 4e 47 20 54 48 45 20 43 |...EDITING THE C| 000003b0 53 56 20 46 49 4c 45 0a 0a 54 6f 20 6f 70 65 6e |SV FILE..To open| 000003c0 20 74 68 65 20 65 64 69 74 6f 72 20 77 69 6e 64 | the editor wind| 000003d0 6f 77 20 69 66 20 69 74 20 69 73 20 6e 6f 74 20 |ow if it is not | 000003e0 61 6c 72 65 61 64 79 20 6f 70 65 6e 2c 20 63 6c |already open, cl| 000003f0 69 63 6b 20 53 65 6c 65 63 74 20 6f 6e 0a 74 68 |ick Select on.th| 00000400 65 20 43 73 76 45 64 69 74 20 69 63 6f 6e 62 61 |e CsvEdit iconba| 00000410 72 20 69 63 6f 6e 2e 20 54 68 65 20 65 64 69 74 |r icon. The edit| 00000420 6f 72 20 77 69 6e 64 6f 77 20 63 6f 6d 70 72 69 |or window compri| 00000430 73 65 73 20 6f 66 20 74 68 65 20 6d 61 69 6e 20 |ses of the main | 00000440 77 6f 72 6b 0a 61 72 65 61 2c 20 73 68 6f 77 69 |work.area, showi| 00000450 6e 67 20 65 61 63 68 20 6f 66 20 74 68 65 20 63 |ng each of the c| 00000460 65 6c 6c 73 20 69 6e 20 61 20 73 65 76 65 6e 20 |ells in a seven | 00000470 62 79 20 74 77 65 6e 74 79 20 67 72 69 64 2e 20 |by twenty grid. | 00000480 42 65 6c 6f 77 20 74 68 69 73 0a 69 73 20 61 20 |Below this.is a | 00000490 74 6f 6f 6c 20 70 61 6e 65 20 77 69 74 68 20 73 |tool pane with s| 000004a0 65 76 65 72 61 6c 20 62 75 74 74 6f 6e 73 2c 20 |everal buttons, | 000004b0 61 20 62 6f 78 20 73 68 6f 77 69 6e 67 20 74 68 |a box showing th| 000004c0 65 20 63 6f 6f 72 64 69 6e 61 74 65 73 20 6f 66 |e coordinates of| 000004d0 0a 74 68 65 20 63 75 72 72 65 6e 74 6c 79 20 73 |.the currently s| 000004e0 65 6c 65 63 74 65 64 20 63 65 6c 6c 20 61 6e 64 |elected cell and| 000004f0 20 61 20 64 61 74 61 20 65 6e 74 72 79 20 61 72 | a data entry ar| 00000500 65 61 2e 0a 0a 43 6c 69 63 6b 69 6e 67 20 6f 6e |ea...Clicking on| 00000510 20 61 6e 79 20 63 65 6c 6c 20 77 69 74 68 20 53 | any cell with S| 00000520 65 6c 65 63 74 20 77 69 6c 6c 20 73 65 6c 65 63 |elect will selec| 00000530 74 20 69 74 2c 20 63 6c 69 63 6b 69 6e 67 20 6f |t it, clicking o| 00000540 6e 20 74 68 65 0a 73 65 6c 65 63 74 65 64 20 63 |n the.selected c| 00000550 65 6c 6c 20 77 69 74 68 20 61 64 6a 75 73 74 20 |ell with adjust | 00000560 77 69 6c 6c 20 72 65 6d 6f 76 65 20 74 68 65 20 |will remove the | 00000570 73 65 6c 65 63 74 69 6f 6e 2e 20 4f 6e 63 65 20 |selection. Once | 00000580 61 20 63 65 6c 6c 20 69 73 0a 73 65 6c 65 63 74 |a cell is.select| 00000590 65 64 20 69 74 20 69 73 20 68 69 67 68 6c 69 67 |ed it is highlig| 000005a0 68 74 65 64 2c 20 61 6e 64 20 69 74 73 20 64 61 |hted, and its da| 000005b0 74 61 20 69 73 20 73 68 6f 77 6e 20 69 6e 20 74 |ta is shown in t| 000005c0 68 65 20 64 61 74 61 20 65 6e 74 72 79 0a 69 63 |he data entry.ic| 000005d0 6f 6e 2e 20 43 75 72 73 6f 72 20 6b 65 79 73 20 |on. Cursor keys | 000005e0 77 69 6c 6c 20 6d 6f 76 65 20 74 6f 20 61 20 64 |will move to a d| 000005f0 69 66 66 65 72 65 6e 74 20 73 65 6c 65 63 74 65 |ifferent selecte| 00000600 64 20 63 65 6c 6c 2e 20 54 6f 20 61 6c 74 65 72 |d cell. To alter| 00000610 20 74 68 65 0a 63 65 6c 6c 2c 20 74 79 70 65 20 | the.cell, type | 00000620 61 6e 79 20 6e 65 77 20 74 65 78 74 20 74 6f 20 |any new text to | 00000630 63 6f 6d 65 20 61 66 74 65 72 20 74 68 65 20 63 |come after the c| 00000640 75 72 72 65 6e 74 20 74 65 78 74 2c 20 6f 72 20 |urrent text, or | 00000650 63 6c 69 63 6b 20 69 6e 0a 74 68 65 20 64 61 74 |click in.the dat| 00000660 61 20 65 6e 74 72 79 20 69 63 6f 6e 2e 0a 0a 43 |a entry icon...C| 00000670 73 76 45 64 69 74 20 61 6c 6c 6f 77 73 20 79 6f |svEdit allows yo| 00000680 75 20 74 6f 20 69 6e 73 65 72 74 20 61 6e 64 20 |u to insert and | 00000690 64 65 6c 65 74 65 20 63 6f 6c 75 6d 6e 73 20 61 |delete columns a| 000006a0 6e 64 20 72 6f 77 73 2e 20 4d 6f 76 65 20 74 68 |nd rows. Move th| 000006b0 65 0a 73 65 6c 65 63 74 65 64 20 63 65 6c 6c 20 |e.selected cell | 000006c0 74 6f 20 74 68 65 20 72 6f 77 20 6f 72 20 63 6f |to the row or co| 000006d0 6c 75 6d 6e 20 69 6e 20 71 75 65 73 74 69 6f 6e |lumn in question| 000006e0 20 61 6e 64 20 63 68 6f 6f 73 65 20 74 68 65 20 | and choose the | 000006f0 72 65 6c 65 76 61 6e 74 0a 65 6e 74 72 79 20 66 |relevant.entry f| 00000700 72 6f 6d 20 74 68 65 20 6d 65 6e 75 2e 20 46 6f |rom the menu. Fo| 00000710 72 20 65 61 73 69 65 72 20 75 73 65 2c 20 74 77 |r easier use, tw| 00000720 6f 20 62 75 74 74 6f 6e 73 20 61 72 65 20 70 72 |o buttons are pr| 00000730 6f 76 69 64 65 64 20 6f 6e 20 74 68 65 0a 74 6f |ovided on the.to| 00000740 6f 6c 62 61 72 20 74 6f 20 64 6f 20 74 68 69 73 |olbar to do this| 00000750 20 74 61 73 6b 2e 20 43 6c 69 63 6b 69 6e 67 20 | task. Clicking | 00000760 6f 6e 20 74 68 65 20 63 6f 6c 75 6d 6e 73 20 69 |on the columns i| 00000770 63 6f 6e 20 77 69 74 68 20 53 65 6c 65 63 74 0a |con with Select.| 00000780 69 6e 73 65 72 74 73 20 61 20 63 6f 6c 75 6d 6e |inserts a column| 00000790 2c 20 63 6c 69 63 6b 69 6e 67 20 6f 6e 20 69 74 |, clicking on it| 000007a0 20 77 69 74 68 20 41 64 6a 75 73 74 20 72 65 6d | with Adjust rem| 000007b0 6f 76 65 73 20 61 20 63 6f 6c 75 6d 6e 2e 20 54 |oves a column. T| 000007c0 68 65 0a 6f 70 65 72 61 74 69 6f 6e 20 6f 66 20 |he.operation of | 000007d0 74 68 65 20 72 6f 77 73 20 62 75 74 74 6f 6e 20 |the rows button | 000007e0 69 73 20 73 69 6d 69 6c 61 72 2e 0a 0a 54 68 65 |is similar...The| 000007f0 20 64 65 6c 65 74 65 20 61 6c 6c 20 6d 61 69 6e | delete all main| 00000800 20 6d 65 6e 75 20 65 6e 74 72 79 20 77 69 6c 6c | menu entry will| 00000810 20 77 69 70 65 20 61 6c 6c 20 74 68 65 20 63 75 | wipe all the cu| 00000820 72 72 65 6e 74 20 64 61 74 61 2e 20 49 66 20 74 |rrent data. If t| 00000830 68 65 0a 66 69 6c 65 20 68 61 73 20 62 65 65 6e |he.file has been| 00000840 20 6d 6f 64 69 66 69 65 64 2c 20 43 73 76 45 64 | modified, CsvEd| 00000850 69 74 20 61 73 6b 73 20 66 6f 72 20 63 6f 6e 66 |it asks for conf| 00000860 69 72 6d 61 74 69 6f 6e 20 6f 66 20 74 68 69 73 |irmation of this| 00000870 0a 6f 70 65 72 61 74 69 6f 6e 2e 0a 0a 53 41 56 |.operation...SAV| 00000880 49 4e 47 20 54 48 45 20 43 53 56 46 49 4c 45 0a |ING THE CSVFILE.| 00000890 0a 54 68 65 20 73 61 76 65 20 64 69 61 6c 6f 67 |.The save dialog| 000008a0 75 65 20 62 6f 78 20 66 72 6f 6d 20 74 68 65 20 |ue box from the | 000008b0 6d 61 69 6e 20 6d 65 6e 75 20 61 6c 6c 6f 77 73 |main menu allows| 000008c0 20 79 6f 75 20 74 6f 20 64 6f 20 74 68 69 73 20 | you to do this | 000008d0 69 6e 20 74 68 65 0a 6e 6f 72 6d 61 6c 20 52 69 |in the.normal Ri| 000008e0 73 63 20 4f 73 20 6d 61 6e 6e 65 72 2e 20 41 6c |sc Os manner. Al| 000008f0 74 65 72 6e 61 74 69 76 65 6c 79 2c 20 63 6c 69 |ternatively, cli| 00000900 63 6b 20 6f 6e 20 74 68 65 20 73 61 76 65 20 74 |ck on the save t| 00000910 6f 6f 6c 62 61 72 20 69 63 6f 6e 2e 0a 54 68 69 |oolbar icon..Thi| 00000920 73 20 68 61 73 20 74 68 65 20 73 61 6d 65 20 65 |s has the same e| 00000930 66 66 65 63 74 20 61 73 20 63 6c 69 63 6b 69 6e |ffect as clickin| 00000940 67 20 6f 6e 20 74 68 65 20 53 61 76 65 20 6d 65 |g on the Save me| 00000950 6e 75 20 65 6e 74 72 79 3b 20 69 74 20 6f 70 65 |nu entry; it ope| 00000960 6e 73 0a 61 20 73 61 76 65 20 64 69 61 6c 6f 67 |ns.a save dialog| 00000970 75 65 20 62 6f 78 20 69 66 20 74 68 69 73 20 69 |ue box if this i| 00000980 73 20 61 20 6e 65 77 20 66 69 6c 65 2c 20 6f 72 |s a new file, or| 00000990 20 73 61 76 65 73 20 69 74 20 62 61 63 6b 20 77 | saves it back w| 000009a0 68 65 72 65 20 69 74 0a 77 61 73 20 6c 6f 61 64 |here it.was load| 000009b0 65 64 20 66 72 6f 6d 20 69 66 20 6e 6f 74 2e 0a |ed from if not..| 000009c0 0a 43 53 56 45 44 49 54 27 53 20 55 53 45 20 57 |.CSVEDIT'S USE W| 000009d0 49 54 48 20 47 52 41 50 48 50 4c 55 53 0a 0a 46 |ITH GRAPHPLUS..F| 000009e0 6f 72 20 75 73 65 72 73 20 6f 66 20 47 72 61 70 |or users of Grap| 000009f0 68 50 6c 75 73 2c 20 6e 6f 74 65 20 74 68 61 74 |hPlus, note that| 00000a00 20 74 68 65 20 43 53 56 20 66 69 6c 65 20 63 61 | the CSV file ca| 00000a10 6e 6e 6f 74 20 62 65 20 64 72 61 67 67 65 64 0a |nnot be dragged.| 00000a20 73 74 72 61 69 67 68 74 20 69 6e 74 6f 20 74 68 |straight into th| 00000a30 65 20 67 72 61 70 68 20 70 72 6f 63 65 73 73 6f |e graph processo| 00000a40 72 20 62 75 74 20 6d 75 73 74 20 62 65 20 73 61 |r but must be sa| 00000a50 76 65 64 20 74 6f 20 61 20 70 68 79 73 69 63 61 |ved to a physica| 00000a60 6c 20 66 69 6c 65 0a 61 6e 64 20 74 68 65 6e 20 |l file.and then | 00000a70 73 68 6f 77 6e 20 74 6f 20 47 72 61 70 68 50 6c |shown to GraphPl| 00000a80 75 73 2e 0a 0a 50 6c 65 61 73 65 20 6e 6f 74 65 |us...Please note| 00000a90 20 74 68 61 74 20 74 68 65 72 65 20 69 73 20 6f | that there is o| 00000aa0 6e 65 20 61 73 20 79 65 74 20 75 6e 75 73 65 64 |ne as yet unused| 00000ab0 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 20 74 | button on the t| 00000ac0 6f 6f 6c 62 61 72 2e 0a 54 68 69 73 20 77 69 6c |oolbar..This wil| 00000ad0 6c 20 62 65 20 75 73 65 64 20 69 6e 20 70 6f 73 |l be used in pos| 00000ae0 73 69 62 6c 65 20 66 75 74 75 72 65 20 76 65 72 |sible future ver| 00000af0 73 69 6f 6e 73 20 6f 66 20 43 73 76 45 64 69 74 |sions of CsvEdit| 00000b00 2e 0a |..| 00000b02
.