OK that's a nice trick. Very useful for CSV files. Thanks! 2017-03-12 16:52 GMT+00:00 Scott Randby <sran...@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 <vicente...@gmail.com > > <mailto:vicente...@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 <zelt...@gmail.com > > <mailto:zelt...@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 > > > > > > > >
