From mboxrd@z Thu Jan 1 00:00:00 1970 From: Scott Randby Subject: Re: Complex conversion of text to org table Date: Sun, 12 Mar 2017 12:46:22 -0400 Message-ID: <8f1563ce-dba6-9e9a-eae6-e96022eb78d2@gmail.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35976) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cn6da-000462-9L for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 12:46:31 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cn6dZ-0000kv-CL for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 12:46:30 -0400 Received: from mail-io0-x241.google.com ([2607:f8b0:4001:c06::241]:32947) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cn6dZ-0000kn-5l for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 12:46:29 -0400 Received: by mail-io0-x241.google.com with SMTP id f84so11351110ioj.0 for ; Sun, 12 Mar 2017 09:46:28 -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: Xebar Saram , org mode 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 You can try using commas to separate items. List with commas inserted: 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 (Notice that I eliminated the comma in "butter, melted") Resulting table: | 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 Randby > > 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 > > >