From mboxrd@z Thu Jan 1 00:00:00 1970 From: John Kitchin Subject: Re: Complex conversion of text to org table Date: Tue, 14 Mar 2017 09:18:12 -0400 Message-ID: References: <57dd8dbc-bc4c-1053-fdab-5151f043417a@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55067) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cnmLE-00086x-Ci for emacs-orgmode@gnu.org; Tue, 14 Mar 2017 09:18:21 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cnmLA-0007cc-9l for emacs-orgmode@gnu.org; Tue, 14 Mar 2017 09:18:20 -0400 Received: from mail-qk0-x241.google.com ([2607:f8b0:400d:c09::241]:35093) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cnmLA-0007cO-4X for emacs-orgmode@gnu.org; Tue, 14 Mar 2017 09:18:16 -0400 Received: by mail-qk0-x241.google.com with SMTP id o135so40982883qke.2 for ; Tue, 14 Mar 2017 06:18:16 -0700 (PDT) In-reply-to: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Vicente Vera Cc: Xebar Saram , Scott Randby , org mode See my solution here: http://emacs.stackexchange.com/questions/31417/function-to-paste-text-as-a-orgmode-table/31425#31425 Vicente Vera writes: > OK that's a nice trick. Very useful for CSV files. Thanks! > > 2017-03-12 16:52 GMT+00:00 Scott Randby : > >> On 03/12/2017 11:35 AM, Xebar Saram wrote: >> > Thx Vicente! >> > >> > Thats a decent idea. can this be all wrapped in a function (i have zero >> > coding skills :)) ? i have hundreds of these tables to convert :) >> > >> > best! >> > >> > Z >> >> OR >> >> 3/4, cup, milk >> 2, tablespoons, white vinegar >> 1, cup, all-purpose flour >> 2, tablespoons, white sugar >> 1, teaspoon, baking powder >> 1/2, teaspoon, baking soda >> 1/2, teaspoon, salt >> 1,, egg >> 2, tablespoons, butter melted >> ,, cooking spray >> >> | 3/4 | cup | milk | >> | 2 | tablespoons | white vinegar | >> | 1 | cup | all-purpose flour | >> | 2 | tablespoons | white sugar | >> | 1 | teaspoon | baking powder | >> | 1/2 | teaspoon | baking soda | >> | 1/2 | teaspoon | salt | >> | 1 | | egg | >> | 2 | tablespoons | butter melted | >> | | | cooking spray | >> >> Scott >> >> > >> > On Sun, Mar 12, 2017 at 5:26 PM, Vicente Vera > > > wrote: >> > >> > Hello. In this case Org splits into columns everytime it sees a >> > space, so "baking soda" ends up in two columns. A brute force >> > solution: replace the spaces between words that shouldn't be put >> > into separated columns with an underscore: >> > >> > 1_cup all-purpose_flour >> > >> > Convert it to an Org table and then do a quick M-x replace-string to >> > replace '_' with ' '. >> > >> > 2017-03-12 15:14 GMT+00:00 Xebar Saram > > >: >> > >> > Hi list >> > >> > so im trying to use orgmode to collect food recepies. i have one >> > issue which is to convert text based ingridents list into org >> > tables. >> > >> > for example take this list >> > >> > 3/4 cup milk >> > 2 tablespoons white vinegar >> > 1 cup all-purpose flour >> > 2 tablespoons white sugar >> > 1 teaspoon baking powder >> > 1/2 teaspoon baking soda >> > 1/2 teaspoon salt >> > 1 egg >> > 2 tablespoons butter, melted >> > cooking spray >> > >> > if i mark this as a region and issue >> > `org-table-create-or-convert-from-region` this is the result >> > >> > | 3/4 | cup | milk | | | >> > | | | | >> > | 2 | tablespoons | white | vinegar | (%or | better >> > | yet | lemon | juice%) | >> > | 1 | cup | all-purpose | flour | | >> > | | | | >> > | 2 | tablespoons | white | sugar | | >> > | | | | >> > | 1 | teaspoon | baking | powder | | >> > | | | | >> > | 1/2 | teaspoon | baking | soda | | >> > | | | | >> > | 1/2 | teaspoon | salt | | | >> > | | | | >> > | 1 | egg | | | | >> > | | | | >> > | 2 | tablespoons | butter, | melted | | >> > | | | | >> > | cooking | spray | | | | >> > | | | | >> > >> > >> > as you can see it got the amount (1/2) and the unit (cup) right >> > yet the actual ingredients is cut into several columns >> > >> > i dont really know how to deal with this. is there a more >> > intelligent way of auto directing the conversion to split it the >> > correct way? >> > >> > if not any suggestions on how to convert it in a better way? >> > perhaps a command to quick delete the separator (|) across all >> > the column? >> > >> > thx alot in advance >> > >> > Z >> > >> > >> > >> >> -- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu