emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* working with delimited files
@ 2011-07-04 15:18 Sivaram Neelakantan
  0 siblings, 0 replies; 6+ messages in thread
From: Sivaram Neelakantan @ 2011-07-04 15:18 UTC (permalink / raw)
  To: emacs-orgmode

I sometimes work with files looking like this

BEL EQ 13-Jan-2006 978.85 988.9 1050 983 1025 1024.5 1025.94 276666 2838.429191
BEL EQ 16-Jan-2006 1024.5 1030 1043 1001.5 1003.5 1008.65 1027.02 72409 743.655
BEL EQ 17-Jan-2006 1008.65 1010 1030 985.1 993.75 989.95 1013.83 102589 1040.07
BEL EQ 18-Jan-2006 989.95 984 1006.8 963.6 1002.15 999.45 990.75 94266 933.9413

When I have a few thousand rows like this, this becomes difficult to
read, so I tend to

a) M-x org-mode
b) C-x h followed by C-c |

This makes it easier to read as you can see below
| BEL | EQ | 02-Jan-2006 |  993.15 |     998 |    1001 |     983 |..
| BEL | EQ | 03-Jan-2006 |  989.05 |   999.5 |    1000 |   989.9 |..
| BEL | EQ | 04-Jan-2006 |  994.35 |     998 |    1014 |  986.15 |..

How do I use the overlay for editing but keep the underlying file
structure?  If I do an C-C C-e, I get unnecessary headers and the
fields are tabbed out and I have to save it as a different
file. Ideally, I'd like to keep the file structure as it is and just
use org-mode to provide viewing structure while editing.


 sivaram
 -- 

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: working with delimited files
  2011-07-08  8:29   ` Rainer M Krug
@ 2011-07-08 10:20     ` Sivaram Neelakantan
  0 siblings, 0 replies; 6+ messages in thread
From: Sivaram Neelakantan @ 2011-07-08 10:20 UTC (permalink / raw)
  To: emacs-orgmode

On Fri, Jul 08 2011,Rainer M Krug Rainer M Krug wrote:


[snipped 20 lines]

> Definitely useful -  a read-only viewer of delimited files, would be a
> useful feature (and sometimes safer then an editor) which I would use
> regularly.
>
> But a really nice feature would be to be able to open a delimited file as a
> table, then being able to edit it using all the usual org features for
> tables, and being able to export the table to the delimited format again,
> while at the same time being able to save the org file. So there would be
> two aspects:
>
> 1) import delimited file into org-table
> 2) export of table into delimited format
>
> Both in itself would be very useful, but together they would be brilliant.

Exactly!  And auto-{number/name}ing of the columns when importing would
also be nice.


[snipped 10 lines]


 sivaram
 -- 

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: working with delimited files
  2011-07-08  8:12 ` Bastien
  2011-07-08  8:29   ` Rainer M Krug
@ 2011-07-08 10:18   ` Sivaram Neelakantan
  1 sibling, 0 replies; 6+ messages in thread
From: Sivaram Neelakantan @ 2011-07-08 10:18 UTC (permalink / raw)
  To: emacs-orgmode

On Fri, Jul 08 2011,Bastien  wrote:

> Hi Sivaram,
>
> Sivaram Neelakantan <nsivaram.net@gmail.com> writes:
>
>> This makes it easier to read as you can see below
>> | BEL | EQ | 02-Jan-2006 |  993.15 |     998 |    1001 |     983 |..
>> | BEL | EQ | 03-Jan-2006 |  989.05 |   999.5 |    1000 |   989.9 |..
>> | BEL | EQ | 04-Jan-2006 |  994.35 |     998 |    1014 |  986.15 |..
>>
>> How do I use the overlay for editing but keep the underlying file
>> structure?  
>
> I can see a solution where you could add an overlay to display the table
> (say, with C-u C-c |, for example) but you won't be able to *edit*.

Right, I'm able to read the file as a table using C-C |, though it
ends up as a changed buffer.  For simple viewing, I really do not mind
the current set up that just modifies the buffer I.e C-c| is good
enough(an option to open read-only would be nice).


However, it's the ability to use the overlay to edit and save it back
in the same format as in the original file is what I was looking for.


 sivaram
 -- 

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: working with delimited files
  2011-07-08  8:12 ` Bastien
@ 2011-07-08  8:29   ` Rainer M Krug
  2011-07-08 10:20     ` Sivaram Neelakantan
  2011-07-08 10:18   ` Sivaram Neelakantan
  1 sibling, 1 reply; 6+ messages in thread
From: Rainer M Krug @ 2011-07-08  8:29 UTC (permalink / raw)
  To: Bastien; +Cc: Sivaram Neelakantan, emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 1752 bytes --]

On Fri, Jul 8, 2011 at 10:12 AM, Bastien <bzg@altern.org> wrote:

> Hi Sivaram,
>
> Sivaram Neelakantan <nsivaram.net@gmail.com> writes:
>
> > This makes it easier to read as you can see below
> > | BEL | EQ | 02-Jan-2006 |  993.15 |     998 |    1001 |     983 |..
> > | BEL | EQ | 03-Jan-2006 |  989.05 |   999.5 |    1000 |   989.9 |..
> > | BEL | EQ | 04-Jan-2006 |  994.35 |     998 |    1014 |  986.15 |..
> >
> > How do I use the overlay for editing but keep the underlying file
> > structure?
>
> I can see a solution where you could add an overlay to display the table
> (say, with C-u C-c |, for example) but you won't be able to *edit*.
>
> Would that be something you (and others) would find useful?
>

Definitely useful -  a read-only viewer of delimited files, would be a
useful feature (and sometimes safer then an editor) which I would use
regularly.

But a really nice feature would be to be able to open a delimited file as a
table, then being able to edit it using all the usual org features for
tables, and being able to export the table to the delimited format again,
while at the same time being able to save the org file. So there would be
two aspects:

1) import delimited file into org-table
2) export of table into delimited format

Both in itself would be very useful, but together they would be brilliant.

Rainer



> --
>  Bastien
>
>


-- 
Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology,
UCT), Dipl. Phys. (Germany)

Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa

Tel :       +33 - (0)9 53 10 27 44
Cell:       +33 - (0)6 85 62 59 98
Fax (F):       +33 - (0)9 58 10 27 44

Fax (D):    +49 - (0)3 21 21 25 22 44

email:      Rainer@krugs.de

Skype:      RMkrug

[-- Attachment #2: Type: text/html, Size: 2631 bytes --]

^ permalink raw reply	[flat|nested] 6+ messages in thread

* Re: working with delimited files
  2011-07-04 15:17 Sivaram Neelakantan
@ 2011-07-08  8:12 ` Bastien
  2011-07-08  8:29   ` Rainer M Krug
  2011-07-08 10:18   ` Sivaram Neelakantan
  0 siblings, 2 replies; 6+ messages in thread
From: Bastien @ 2011-07-08  8:12 UTC (permalink / raw)
  To: Sivaram Neelakantan; +Cc: emacs-orgmode

Hi Sivaram,

Sivaram Neelakantan <nsivaram.net@gmail.com> writes:

> This makes it easier to read as you can see below
> | BEL | EQ | 02-Jan-2006 |  993.15 |     998 |    1001 |     983 |..
> | BEL | EQ | 03-Jan-2006 |  989.05 |   999.5 |    1000 |   989.9 |..
> | BEL | EQ | 04-Jan-2006 |  994.35 |     998 |    1014 |  986.15 |..
>
> How do I use the overlay for editing but keep the underlying file
> structure?  

I can see a solution where you could add an overlay to display the table
(say, with C-u C-c |, for example) but you won't be able to *edit*.

Would that be something you (and others) would find useful?

-- 
 Bastien

^ permalink raw reply	[flat|nested] 6+ messages in thread

* working with delimited files
@ 2011-07-04 15:17 Sivaram Neelakantan
  2011-07-08  8:12 ` Bastien
  0 siblings, 1 reply; 6+ messages in thread
From: Sivaram Neelakantan @ 2011-07-04 15:17 UTC (permalink / raw)
  To: emacs-orgmode

I sometimes work with files looking like this

BEL EQ 13-Jan-2006 978.85 988.9 1050 983 1025 1024.5 1025.94 276666 2838.429191
BEL EQ 16-Jan-2006 1024.5 1030 1043 1001.5 1003.5 1008.65 1027.02 72409 743.655
BEL EQ 17-Jan-2006 1008.65 1010 1030 985.1 993.75 989.95 1013.83 102589 1040.07
BEL EQ 18-Jan-2006 989.95 984 1006.8 963.6 1002.15 999.45 990.75 94266 933.9413

When I have a few thousand rows like this, this becomes difficult to
read, so I tend to

a) M-x org-mode
b) C-x h followed by C-c |

This makes it easier to read as you can see below
| BEL | EQ | 02-Jan-2006 |  993.15 |     998 |    1001 |     983 |..
| BEL | EQ | 03-Jan-2006 |  989.05 |   999.5 |    1000 |   989.9 |..
| BEL | EQ | 04-Jan-2006 |  994.35 |     998 |    1014 |  986.15 |..

How do I use the overlay for editing but keep the underlying file
structure?  If I do an C-C C-e, I get unnecessary headers and the
fields are tabbed out and I have to save it as a different
file. Ideally, I'd like to keep the file structure as it is and just
use org-mode to provide viewing structure while editing.


 sivaram
 -- 

^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2011-07-08 10:25 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2011-07-04 15:18 working with delimited files Sivaram Neelakantan
  -- strict thread matches above, loose matches on Subject: below --
2011-07-04 15:17 Sivaram Neelakantan
2011-07-08  8:12 ` Bastien
2011-07-08  8:29   ` Rainer M Krug
2011-07-08 10:20     ` Sivaram Neelakantan
2011-07-08 10:18   ` Sivaram Neelakantan

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).