Re: Complex conversion of text to org table

[Vicente Vera <vicentemvp@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 4074 bytes --]

OK that's a nice trick. Very useful for CSV files. Thanks!

2017-03-12 16:52 GMT+00:00 Scott Randby <srandby@gmail.com>:

> 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 <vicentemvp@gmail.com
> > <mailto:vicentemvp@gmail.com>> 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 <zeltakc@gmail.com
> >     <mailto:zeltakc@gmail.com>>:
> >
> >         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
> >
> >
> >
>
>

[-- Attachment #2: Type: text/html, Size: 5991 bytes --]