* Export the org spreadsheet into a tab seperated text file @ 2008-07-11 18:42 Csányi Pál 2008-07-11 19:39 ` Bernt Hansen 0 siblings, 1 reply; 9+ messages in thread From: Csányi Pál @ 2008-07-11 18:42 UTC (permalink / raw) To: emacs-orgmode Hello! Is there available from Org-mode to export a table to a Tab separated text file? -- Regards, Paul Csanyi http://www.freewebs.com/csanyi-pal/index.htm ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Export the org spreadsheet into a tab seperated text file 2008-07-11 18:42 Export the org spreadsheet into a tab seperated text file Csányi Pál @ 2008-07-11 19:39 ` Bernt Hansen 2008-07-11 21:08 ` Re: Export the org spreadsheet into a tab seperated textfile Parker, Matthew 2008-07-12 8:41 ` Export the org spreadsheet into a tab seperated text file Csányi Pál 0 siblings, 2 replies; 9+ messages in thread From: Bernt Hansen @ 2008-07-11 19:39 UTC (permalink / raw) To: Csányi Pál; +Cc: emacs-orgmode csanyipal@gmail.com (Csányi Pál) writes: > Hello! > > Is there available from Org-mode to export a table to a Tab separated > text file? Hi! Yes it's easy. Put the pointer on the table and M-x org-table-export Export table to: /tmp/some-table.txt Format: orgtbl-to-tsv HTH, Bernt ^ permalink raw reply [flat|nested] 9+ messages in thread
* RE: Re: Export the org spreadsheet into a tab seperated textfile 2008-07-11 19:39 ` Bernt Hansen @ 2008-07-11 21:08 ` Parker, Matthew 2008-07-11 21:12 ` Bernt Hansen 2008-07-12 8:41 ` Export the org spreadsheet into a tab seperated text file Csányi Pál 1 sibling, 1 reply; 9+ messages in thread From: Parker, Matthew @ 2008-07-11 21:08 UTC (permalink / raw) To: Bernt Hansen, Csányi Pál; +Cc: emacs-orgmode Sorry, But, can you describe exactly what you mean by "Put the pointer on the table" I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading" Thanks! [p] | *one* | *two*| *three*| | asdf | asdf | asdf | | 1 | 1 | 1 | [p] | *one* | *two*| *three*| | asdf | asdf | asdf | | 1 | 1 | 1 | |[p] *one* | *two*| *three*| | asdf | asdf | asdf | | 1 | 1 | 1 | | asdf | asdf | asdf | | 1 | 1 | 1 | [p] -----Original Message----- From: emacs-orgmode-bounces+mparker=seic.com@gnu.org [mailto:emacs-orgmode-bounces+mparker=seic.com@gnu.org] On Behalf Of Bernt Hansen Sent: Friday, July 11, 2008 3:39 PM To: Csányi Pál Cc: emacs-orgmode@gnu.org Subject: [Orgmode] Re: Export the org spreadsheet into a tab seperated textfile csanyipal@gmail.com (Csányi Pál) writes: > Hello! > > Is there available from Org-mode to export a table to a Tab separated > text file? Hi! Yes it's easy. Put the pointer on the table and M-x org-table-export Export table to: /tmp/some-table.txt Format: orgtbl-to-tsv HTH, Bernt _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Re: Export the org spreadsheet into a tab seperated textfile 2008-07-11 21:08 ` Re: Export the org spreadsheet into a tab seperated textfile Parker, Matthew @ 2008-07-11 21:12 ` Bernt Hansen 2008-07-11 21:25 ` Parker, Matthew 2008-07-14 21:56 ` Carsten Dominik 0 siblings, 2 replies; 9+ messages in thread From: Bernt Hansen @ 2008-07-11 21:12 UTC (permalink / raw) To: Parker, Matthew; +Cc: Csányi Pál, emacs-orgmode "Parker, Matthew" <MParker@seic.com> writes: > But, can you describe exactly what you mean by "Put the pointer on the table" > > I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading" > > Thanks! > > [p] > | *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > > [p] | *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > |[p] *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > > > | asdf | asdf | asdf | > | 1 | 1 | 1 | > [p] The middle two above should work fine as long as you have a heading before it. Just insert a line * Test in front of the table. Put the point on the table is just put the cursor anywhere inside the table. -Bernt ^ permalink raw reply [flat|nested] 9+ messages in thread
* RE: Re: Export the org spreadsheet into a tab seperated textfile 2008-07-11 21:12 ` Bernt Hansen @ 2008-07-11 21:25 ` Parker, Matthew 2008-07-14 21:56 ` Carsten Dominik 1 sibling, 0 replies; 9+ messages in thread From: Parker, Matthew @ 2008-07-11 21:25 UTC (permalink / raw) To: Bernt Hansen; +Cc: Csányi Pál, emacs-orgmode Worked. Thanks. -----Original Message----- From: Bernt Hansen [mailto:bernt@norang.ca] Sent: Friday, July 11, 2008 5:12 PM To: Parker, Matthew Cc: Csányi Pál; emacs-orgmode@gnu.org Subject: Re: [Orgmode] Re: Export the org spreadsheet into a tab seperated textfile "Parker, Matthew" <MParker@seic.com> writes: > But, can you describe exactly what you mean by "Put the pointer on the table" > > I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading" > > Thanks! > > [p] > | *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > > [p] | *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > |[p] *one* | *two*| *three*| > | asdf | asdf | asdf | > | 1 | 1 | 1 | > > > > | asdf | asdf | asdf | > | 1 | 1 | 1 | > [p] The middle two above should work fine as long as you have a heading before it. Just insert a line * Test in front of the table. Put the point on the table is just put the cursor anywhere inside the table. -Bernt ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Re: Export the org spreadsheet into a tab seperated textfile 2008-07-11 21:12 ` Bernt Hansen 2008-07-11 21:25 ` Parker, Matthew @ 2008-07-14 21:56 ` Carsten Dominik 1 sibling, 0 replies; 9+ messages in thread From: Carsten Dominik @ 2008-07-14 21:56 UTC (permalink / raw) To: Bernt Hansen Cc: Csányi Pál, emacs-orgmode, Parker, Matthew On Jul 11, 2008, at 2:12 PM, Bernt Hansen wrote: > "Parker, Matthew" <MParker@seic.com> writes: > >> But, can you describe exactly what you mean by "Put the pointer on >> the table" >> >> I tried putting point in various places (indicated w/ "[p]" below) >> and ran M-x org-table-export. But got messages: "No Table at point" >> or "before first heading" >> >> Thanks! >> >> [p] >> | *one* | *two*| *three*| >> | asdf | asdf | asdf | >> | 1 | 1 | 1 | >> >> >> [p] | *one* | *two*| *three*| >> | asdf | asdf | asdf | >> | 1 | 1 | 1 | >> >> |[p] *one* | *two*| *three*| >> | asdf | asdf | asdf | >> | 1 | 1 | 1 | >> >> >> >> | asdf | asdf | asdf | >> | 1 | 1 | 1 | >> [p] > > The middle two above should work fine as long as you have a heading > before it. Just insert a line > > * Test > > in front of the table. Oops, this should not be required. Fixed now. Also, your post reminded me that there should be completion for the translator functions, this works now as well. Thanks. - Carsten ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Export the org spreadsheet into a tab seperated text file 2008-07-11 19:39 ` Bernt Hansen 2008-07-11 21:08 ` Re: Export the org spreadsheet into a tab seperated textfile Parker, Matthew @ 2008-07-12 8:41 ` Csányi Pál 2008-07-14 18:38 ` Carsten Dominik 1 sibling, 1 reply; 9+ messages in thread From: Csányi Pál @ 2008-07-12 8:41 UTC (permalink / raw) To: emacs-orgmode Bernt Hansen <bernt@norang.ca> writes: > csanyipal@gmail.com (Csányi Pál) writes: >> Is there available from Org-mode to export a table to a Tab separated >> text file? > Yes it's easy. Put the pointer on the table and M-x org-table-export > Export table to: /tmp/some-table.txt > Format: orgtbl-to-tsv OK it works but only for one org table at a time. But what to do if I have an org file with more than one table with different columns x rows and between these tables moreover I have some text, like the follows: [options] Here is an org tabe. [pins] Here is an org tabe. etc. Can I export in org mode the whole file with these tables end texts mixed this way in to one Tab separated text file? (Tab separated only where was an org table so in this example abowe in tab separated text file there should to get two places with tab separated rows that contain datas taken from the tables.)? -- Regards, Paul Csanyi http://www.freewebs.com/csanyi-pal/index.htm ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Re: Export the org spreadsheet into a tab seperated text file 2008-07-12 8:41 ` Export the org spreadsheet into a tab seperated text file Csányi Pál @ 2008-07-14 18:38 ` Carsten Dominik 2008-07-14 22:25 ` Csányi Pál 0 siblings, 1 reply; 9+ messages in thread From: Carsten Dominik @ 2008-07-14 18:38 UTC (permalink / raw) To: Csányi Pál; +Cc: emacs-orgmode On Jul 12, 2008, at 1:41 AM, Csányi Pál wrote: > Bernt Hansen <bernt@norang.ca> writes: > >> csanyipal@gmail.com (Csányi Pál) writes: > >>> Is there available from Org-mode to export a table to a Tab >>> separated >>> text file? > >> Yes it's easy. Put the pointer on the table and M-x org-table-export >> Export table to: /tmp/some-table.txt >> Format: orgtbl-to-tsv > > OK it works but only for one org table at a time. > > But what to do if I have an org file with more than one table with > different columns x rows and between these tables moreover I have some > text, like the follows: > > [options] > > Here is an org tabe. > > [pins] > > Here is an org tabe. > > etc. > > Can I export in org mode the whole file with these tables end texts > mixed this way in to one Tab separated text file? (Tab separated only > where was an org table so in this example abowe in tab separated text > file there should to get two places with tab separated rows that > contain datas taken from the tables.)? No, you cannot. What would be the application for this? - Carsten ^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Export the org spreadsheet into a tab seperated text file 2008-07-14 18:38 ` Carsten Dominik @ 2008-07-14 22:25 ` Csányi Pál 0 siblings, 0 replies; 9+ messages in thread From: Csányi Pál @ 2008-07-14 22:25 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 2412 bytes --] Carsten Dominik <dominik@uva.nl> writes: > On Jul 12, 2008, at 1:41 AM, Csányi Pál wrote: > >> Bernt Hansen <bernt@norang.ca> writes: >> >>> csanyipal@gmail.com (Csányi Pál) writes: >> >>>> Is there available from Org-mode to export a table to a Tab >>>> separated >>>> text file? >> >>> Yes it's easy. Put the pointer on the table and M-x org-table-export >>> Export table to: /tmp/some-table.txt >>> Format: orgtbl-to-tsv >> >> OK it works but only for one org table at a time. >> >> But what to do if I have an org file with more than one table with >> different columns x rows and between these tables moreover I have some >> text, like the follows: >> >> [options] >> >> Here is an org tabe. >> >> [pins] >> >> Here is an org tabe. >> >> etc. >> >> Can I export in org mode the whole file with these tables end texts >> mixed this way in to one Tab separated text file? (Tab separated only >> where was an org table so in this example abowe in tab separated text >> file there should to get two places with tab separated rows that >> contain datas taken from the tables.)? > > > No, you cannot. What would be the application for this? If I would get the tab separated text file from org tables, then I would be to run on it the tragesym python script. Tragesym can to make from this tab separated text file an electric symbol for gEDA suite. http://geda.seul.org/wiki/geda:tragesym_readme However, I can now to send an org table within org file to tab separated lines. I run orgtbl-send-table on every org-table in the org file. After that I can to run on this org file tragesym, but get an error message in some circumstances. If I edit one table in this org file so that I put '#' character at start of every line then I get the electric symbol file when run tragesym on the org file. If I leave the file unedited then I get error message: Traceback (most recent call last): File "/usr/local/geda-0.0.2/bin/.scripts/tragesym.py", line 586, in <module> opts,attr,pins=readsrc(file_in) File "/usr/local/geda-0.0.2/bin/.scripts/tragesym.py", line 143, in readsrc geda_attr[(string.strip(element[0]),nr)]=string.strip(element[1]) IndexError: list index out of range But this is maybe the issue for the geda news group: gmane.comp.cad.geda.user The file with edited lines that don't cause this error because of '#' characters at beginning of the lines is attached here.. [-- Attachment #2: The edited org file with '#' characters at one torg table --] [-- Type: application/octet-stream, Size: 3852 bytes --] # This is the template file for creating symbols with tragesym # every line starting with '#' is a comment line. [options] # wordswap swaps labels if the pin is on the right side an looks like # this: # "PB1 (CLK)". That's useful for micro controller port labels # rotate_labels rotates the pintext of top and bottom pins # this is useful for large symbols like FPGAs with more than 100 pins # sort_labels will sort the pins by it's labels # useful for address ports, busses, ... #+ORGTBL: SEND options orgtbl-to-generic :tstart "" :tend "" :lstart "" :lend "" :sep "\t" | wordswap | yes | | rotate_labels | no | | sort_labels | yes | | generate_pinseq | yes | | sym_width | 1400 | | pinwidthvertical | 400 | | pinwidthhorizontal | 400 | # BEGIN RECEIVE ORGTBL options # wordswap yes rotate_labels no sort_labels yes generate_pinseq yes sym_width 1400 pinwidthvertical 400 pinwidthhorizontal 400 # END RECEIVE ORGTBL options # [geda_attr] # name will be printed in the top of the symbol # if you have a device with slots, you'll have to use slot= and # slotdef= # use comment= if there are special information you want to add #+ORGTBL: SEND geda_attr orgtbl-to-generic :tstart "" :tend "" :lstart "" :lend "" :sep "\t" #| version | 20080127 1 | #| name | MCT6 | #| device | DUAL_PHTR_OPTCPLR | #| refdes | U? | #| footprint | none | #| description | dual phototransistor optocoupler | #| documentation | http://www.fairchildsemi.com/ds/MC/MCT6.pdf | #| author | Paul Csanyi | #| numslots | 0 | #| dist-license | GPL | #| use-license | unlimited | # BEGIN RECEIVE ORGTBL geda_attr # version 20080127 1 name MCT6 device DUAL_PHTR_OPTCPLR refdes U? footprint none description dual phototransistor optocoupler documentation http://www.fairchildsemi.com/ds/MC/MCT6.pdf author Paul Csanyi numslots 0 dist-license GPL use-license unlimited # END RECEIVE ORGTBL geda_attr # [pins] # tabseparated list of pin descriptions # ---------------------------------------- # pinnr is the physical number of the pin # seq is the pinseq= attribute, leave it blank if it doesn't matter # type can be (in, out, io, oc, oe, pas, tp, tri, clk, pwr) # style can be (line,dot,clk,dotclk,none). none if only want to add a # net # posit. can be (l,r,t,b) or empty for nets # net specifies the name of the net. Vcc or GND for example. # label represents the pinlabel. # negation lines can be added with "\_" example: \_enable\_ # if you want to write a "\" use "\\" as escape sequence #----------------------------------------------------- #+ORGTBL: SEND pins orgtbl-to-generic :skip 1 :tstart "" :tend "" :lstart "" :lend "" :sep "\t" | pinnr | seq | type | style | posit. | net | label | | 1 | 1 | pas | line | l | | ANODE | | 2 | 2 | pas | line | l | | CATHODE | | 3 | 3 | pas | line | l | | CATHODE | | 4 | 4 | pas | line | l | | ANODE | | 5 | 5 | pas | line | r | | EMITTER | | 6 | 6 | pas | line | r | | COLLECTOR | | 7 | 7 | pas | line | r | | COLLECTOR | | 8 | 8 | pas | line | r | | EMITTER | # BEGIN RECEIVE ORGTBL pins # 1 1 pas line l ANODE 2 2 pas line l CATHODE 3 3 pas line l CATHODE 4 4 pas line l ANODE 5 5 pas line r EMITTER 6 6 pas line r COLLECTOR 7 7 pas line r COLLECTOR 8 8 pas line r EMITTER # END RECEIVE ORGTBL pins # [-- Attachment #3: Type: text/plain, Size: 259 bytes --] Without these '#' characters at the '[geda_attr]' org table I get the error message: IndexError: list index out of range This is maybe a tragesym bug.. Any advices will be appreciated! -- Regards, Paul Csanyi http://www.freewebs.com/csanyi-pal/index.htm [-- Attachment #4: Type: text/plain, Size: 204 bytes --] _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode ^ permalink raw reply [flat|nested] 9+ messages in thread
end of thread, other threads:[~2008-07-14 22:25 UTC | newest] Thread overview: 9+ messages (download: mbox.gz / follow: Atom feed) -- links below jump to the message on this page -- 2008-07-11 18:42 Export the org spreadsheet into a tab seperated text file Csányi Pál 2008-07-11 19:39 ` Bernt Hansen 2008-07-11 21:08 ` Re: Export the org spreadsheet into a tab seperated textfile Parker, Matthew 2008-07-11 21:12 ` Bernt Hansen 2008-07-11 21:25 ` Parker, Matthew 2008-07-14 21:56 ` Carsten Dominik 2008-07-12 8:41 ` Export the org spreadsheet into a tab seperated text file Csányi Pál 2008-07-14 18:38 ` Carsten Dominik 2008-07-14 22:25 ` Csányi Pál
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).