From mboxrd@z Thu Jan 1 00:00:00 1970 From: Xebar Saram Subject: Complex conversion of text to org table Date: Sun, 12 Mar 2017 17:14:44 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=94eb2c1bc39a0d992e054a8a0ee0 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48678) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cn5Cr-00069m-J9 for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 11:14:50 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cn5Cq-00076k-8H for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 11:14:49 -0400 Received: from mail-pg0-x234.google.com ([2607:f8b0:400e:c05::234]:36242) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cn5Cp-000760-VR for emacs-orgmode@gnu.org; Sun, 12 Mar 2017 11:14:48 -0400 Received: by mail-pg0-x234.google.com with SMTP id g2so37511345pge.3 for ; Sun, 12 Mar 2017 08:14:46 -0700 (PDT) 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: org mode --94eb2c1bc39a0d992e054a8a0ee0 Content-Type: text/plain; charset=UTF-8 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 --94eb2c1bc39a0d992e054a8a0ee0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+SGkgbGlzdDxicj48YnI+c28gPHNwYW4gY2xhc3M9IiIgaWQ9IjoxOHMu MSIgdGFiaW5kZXg9Ii0xIj5pbTwvc3Bhbj4gdHJ5aW5nIHRvIHVzZSA8c3BhbiBjbGFzcz0iIiBp ZD0iOjE4cy4yIiB0YWJpbmRleD0iLTEiPm9yZ21vZGU8L3NwYW4+IHRvIGNvbGxlY3QgZm9vZCA8 c3BhbiBjbGFzcz0iIiBpZD0iOjE4cy4zIiB0YWJpbmRleD0iLTEiPnJlY2VwaWVzPC9zcGFuPi4g aSBoYXZlIG9uZSBpc3N1ZSB3aGljaCBpcyB0byBjb252ZXJ0IHRleHQgYmFzZWQgPHNwYW4gY2xh c3M9IiIgaWQ9IjoxOHMuNCIgdGFiaW5kZXg9Ii0xIj5pbmdyaWRlbnRzPC9zcGFuPiBsaXN0IGlu dG8gb3JnIHRhYmxlcy48YnI+PGJyPmZvciBleGFtcGxlIHRha2UgdGhpcyBsaXN0PGJyPjxicj4z LzQgY3VwIG1pbGs8YnI+MiB0YWJsZXNwb29ucyB3aGl0ZSB2aW5lZ2FyIDxicj4xIGN1cCBhbGwt cHVycG9zZSBmbG91cjxicj4yIHRhYmxlc3Bvb25zIHdoaXRlIHN1Z2FyPGJyPjEgdGVhc3Bvb24g YmFraW5nIHBvd2Rlcjxicj4xLzIgdGVhc3Bvb24gYmFraW5nIHNvZGE8YnI+MS8yIHRlYXNwb29u IHNhbHQ8YnI+MSBlZ2c8YnI+MiB0YWJsZXNwb29ucyBidXR0ZXIsIG1lbHRlZDxicj5jb29raW5n IHNwcmF5IDxicj48YnI+aWYgaSBtYXJrIHRoaXMgYXMgYSByZWdpb24gYW5kIGlzc3VlIGBvcmct dGFibGUtY3JlYXRlLW9yLWNvbnZlcnQtZnJvbS1yZWdpb25gIHRoaXMgaXMgdGhlIHJlc3VsdDxk aXY+PGJyPjwvZGl2PjxkaXY+PGRpdj58IMKgIMKgIDMvNCB8IGN1cCDCoCDCoCDCoCDCoCB8IG1p bGsgwqAgwqAgwqAgwqB8IMKgIMKgIMKgIMKgIHwgwqAgwqAgwqB8IMKgIMKgIMKgIMKgfCDCoCDC oCB8IMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgfDwvZGl2PjxkaXY+fCDCoCDCoCDCoCAyIHwgdGFi bGVzcG9vbnMgfCB3aGl0ZSDCoCDCoCDCoCB8IHZpbmVnYXIgfCAoJW9yIHwgYmV0dGVyIHwgeWV0 IHwgbGVtb24gfCBqdWljZSUpIHw8L2Rpdj48ZGl2PnwgwqAgwqAgwqAgMSB8IGN1cCDCoCDCoCDC oCDCoCB8IGFsbC1wdXJwb3NlIHwgZmxvdXIgwqAgfCDCoCDCoCDCoHwgwqAgwqAgwqAgwqB8IMKg IMKgIHwgwqAgwqAgwqAgfCDCoCDCoCDCoCDCoCB8PC9kaXY+PGRpdj58IMKgIMKgIMKgIDIgfCB0 YWJsZXNwb29ucyB8IHdoaXRlIMKgIMKgIMKgIHwgc3VnYXIgwqAgfCDCoCDCoCDCoHwgwqAgwqAg wqAgwqB8IMKgIMKgIHwgwqAgwqAgwqAgfCDCoCDCoCDCoCDCoCB8PC9kaXY+PGRpdj58IMKgIMKg IMKgIDEgfCB0ZWFzcG9vbiDCoCDCoHwgYmFraW5nIMKgIMKgIMKgfCBwb3dkZXIgwqB8IMKgIMKg IMKgfCDCoCDCoCDCoCDCoHwgwqAgwqAgfCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIHw8L2Rpdj48 ZGl2PnwgwqAgwqAgMS8yIHwgdGVhc3Bvb24gwqAgwqB8IGJha2luZyDCoCDCoCDCoHwgc29kYSDC oCDCoHwgwqAgwqAgwqB8IMKgIMKgIMKgIMKgfCDCoCDCoCB8IMKgIMKgIMKgIHwgwqAgwqAgwqAg wqAgfDwvZGl2PjxkaXY+fCDCoCDCoCAxLzIgfCB0ZWFzcG9vbiDCoCDCoHwgc2FsdCDCoCDCoCDC oCDCoHwgwqAgwqAgwqAgwqAgfCDCoCDCoCDCoHwgwqAgwqAgwqAgwqB8IMKgIMKgIHwgwqAgwqAg wqAgfCDCoCDCoCDCoCDCoCB8PC9kaXY+PGRpdj58IMKgIMKgIMKgIDEgfCBlZ2cgwqAgwqAgwqAg wqAgfCDCoCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIHwgwqAgwqAgwqB8IMKgIMKgIMKg IMKgfCDCoCDCoCB8IMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgfDwvZGl2PjxkaXY+fCDCoCDCoCDC oCAyIHwgdGFibGVzcG9vbnMgfCBidXR0ZXIsIMKgIMKgIHwgbWVsdGVkIMKgfCDCoCDCoCDCoHwg wqAgwqAgwqAgwqB8IMKgIMKgIHwgwqAgwqAgwqAgfCDCoCDCoCDCoCDCoCB8PC9kaXY+PGRpdj58 IGNvb2tpbmcgfCBzcHJheSDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAg wqAgfCDCoCDCoCDCoHwgwqAgwqAgwqAgwqB8IMKgIMKgIHwgwqAgwqAgwqAgfCDCoCDCoCDCoCDC oCB8PC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5hcyB5b3Ug Y2FuIHNlZSBpdCBnb3QgdGhlIGFtb3VudCAoMS8yKSBhbmQgdGhlIHVuaXQgKGN1cCkgcmlnaHQg eWV0IHRoZSBhY3R1YWwgaW5ncmVkaWVudHMgaXMgY3V0IGludG8gc2V2ZXJhbCBjb2x1bW5zPC9k aXY+PGRpdj48YnI+PC9kaXY+PGRpdj5pIDxzcGFuIGNsYXNzPSIiIGlkPSI6MThzLjciIHRhYmlu ZGV4PSItMSI+ZG9udDwvc3Bhbj4gcmVhbGx5IGtub3cgaG93IHRvIGRlYWwgd2l0aCB0aGlzLiBp cyB0aGVyZSBhIG1vcmUgaW50ZWxsaWdlbnQgd2F5IG9mIGF1dG8gZGlyZWN0aW5nIHRoZSBjb252 ZXJzaW9uIHRvIHNwbGl0IGl0IHRoZSBjb3JyZWN0IHdheT88L2Rpdj48ZGl2Pjxicj48L2Rpdj48 ZGl2PmlmIG5vdCBhbnkgc3VnZ2VzdGlvbnMgb24gaG93IHRvIGNvbnZlcnQgaXQgaW4gYSBiZXR0 ZXIgd2F5PyBwZXJoYXBzIGEgY29tbWFuZCB0byBxdWljayBkZWxldGUgdGhlIHNlcGFyYXRvciAo fCkgYWNyb3NzIGFsbCB0aGUgY29sdW1uPzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PHNwYW4g Y2xhc3M9IiIgaWQ9IjoxOHMuMTAiIHRhYmluZGV4PSItMSI+dGh4PC9zcGFuPiA8c3BhbiBjbGFz cz0iIiBpZD0iOjE4cy4xMSIgdGFiaW5kZXg9Ii0xIj5hbG90PC9zcGFuPiBpbiBhZHZhbmNlPC9k aXY+PGRpdj48YnI+PC9kaXY+PGRpdj5aPC9kaXY+PC9kaXY+DQo= --94eb2c1bc39a0d992e054a8a0ee0--