[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Complex conversion of text to org table
From: |
John Kitchin |
Subject: |
Re: [O] Complex conversion of text to org table |
Date: |
Tue, 14 Mar 2017 09:18:12 -0400 |
User-agent: |
mu4e 0.9.19; emacs 25.1.1 |
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 <address@hidden>:
>
>> 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 <address@hidden
>> > <mailto:address@hidden>> 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 <address@hidden
>> > <mailto:address@hidden>>:
>> >
>> > 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
Re: [O] Complex conversion of text to org table, Thierry Banel, 2017/03/12