in-text Spreadsheet/Tables

Submitted by turtlecove on Friday, 31 March, 2006 - 17:19

Does anyone know of a plugin that will let me manipulate tables of text in a spreadsheet-like way?
I keep all my life/work information in text files and I'd really like to be able to store structured information in a more usable format.
I am thinking something like a special "tag" that means the follow lines are CSV data.
Eg:

[TABLE fs=|]
Mary Smith|40.34|xyz
John Doe|12.19|abc
Nathan Brazil|234.50|123

And the plug in would recognize this table and display it in a nice grid with some features like sort by column, resize columns, etc.
Maybe even some primitive formulas like SUM(), AVG(), etc.

If I looked at the file in a different text editor I would see the CSV as I typed it above. In jEdit I would see the "pretty" grid.

Anything out there like this? Anything even similar?

copy/paste with Excel

by turtlecove on Fri, 31/03/2006 - 17:37

While the plugin I described would be great, I have found that I can copy and paste between jEdit and Excel. jEdit handles the table data flawlessly, putting TABs in as column separators.

So, it's a bit inconvenient, but until I find that plugin I can copy my table data, paste it into Excel to manipulate it, and copy/paste it back into jEdit.
Still... clicking on a column header to sort it sure would be easier than all that!

Excel

by Robert Schwenn on Fri, 31/03/2006 - 19:18

If You'd use a comma as fieldseparartor instead of "|" and rename the file to *.CSV, the file with the following contents

Mary Smith,40.34,123
John Doe,12.19,abc
Nathan Brazil,234.5,5456544

can be opened, edited and saved directly with Excel...

Robert

CSV

by turtlecove on Sun, 02/04/2006 - 15:24

If I was going to edit it directly in Excel, I might as well name it '.xls' and just use Excel.

I want to have small sections of larger text files represent tables of data. I might have a twenty page text document with several small 10-100 row tables in it that I'd like to edit while in jEdit.
Without a plugin to do this I have to either edit raw CSV which means counting commas to find the right fields, or copy/paste to Excel.
Or maybe a macro/plugin to automatically grab a block of text and send it to an external program would work *almost* as well:

eg: clicking in this block would launch Excel with this data:

[TABLE:inventory.csv]
apple,3.14,4
pear,2.72,8
orange,1.62,15
apricot,1.41,16
plum,0.69,23
peach,1.90,42
[END TABLE]

Or something like that...

tricky

by Robert Schwenn on Sun, 02/04/2006 - 20:13

A beanshell macro wich recognizes and copy the table might not be very hard to realize. But then it had to start/get excel and paste the data in a new table (may be via excel macro?) .... then copy the range from the table (excel macro?) and so on...
Or is there a way in java to control external programs via Windows-automation?

I'm afraid You have to do this work by yourself. :-|

« April 2024
Mo	Tu	We	Th	Fr	Sa	Su
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

file	ver	dls
GdbPlugin for jEdit 4.5+	0.5	1147
Hypersearch results analysis	1.0	2232
German Language Pack for jEdit 5 (up-to-date)	5.3	4141
Goal column macros	1.0	4028
Hyper-search all .txt files in home dir	1	3284
Select line	1.0	3444
Open_Copied_Path.bsh	1.0	8498
Select_All_or_Lines.bsh	1.0	3409
A BeanShell macro script to search and open a recent file or a file in the current directory.	1.0	5630
Select contents in between parentheses (excluding parentheses)	1.0	3539

file	ver	dls
German Localization light	4.4.2.1	82348
Context Free Art (*.cfdg)	0.31	46055
JBuilder scheme	.001	18495
BBEdit scheme	1.0	18116
ColdFusion scheme	1.0	18024
R Edit Mode - extensive version	0.1	17473
Advanced HTML edit mode	1.0	16206
Matlab Edit Mode	1.0	16068
jEdit XP icons	1.0	15229
XP icons for jEdit	1.1	14293

RSS

XML

HTML