Re: extracting values from log file to excel

Posted by donny008 on Apr 27, 2009; 12:27pm
URL: http://imagej.273.s1.nabble.com/extracting-values-from-log-file-to-excel-tp3692768p3692770.html

hey damon

thankyou for the post. i think this also would be one possibility. just that
may be i shud arrange my log file in a better way so that the excel
conversion happens without much complexity. but yes macro would be what i am
trying for guess it wud need more effort and time


don

On Fri, Apr 24, 2009 at 6:52 PM, Damon Poburko <[hidden email]>wrote:

> Hi Donny,
>
> Have you considered saving all of you data in rows of a text file in ImageJ
> then simply import the file into Excel and use the transpose function in
> Excel to swap rows for columns? This doesn't exactly address the problem,
> but it would quite fast.
>
> Cheers,
> Damon
>
>
> Donny George wrote:
>
>> Hello All
>>
>> I am trying to write a macro so that i can extract specific values from
>> the
>> log file to an excel file. I did try to understand the macro
>> CustomTabStatFromResults but guess its too much of info for me.
>>
>> The image sg0000.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 154.7636, Min 30, Max246, STD9.3166
>> Modified Min103, Max188
>> Final details- Mean154.3191, Min 31, Max242, STD8.7668
>> The image sg0001.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 155.1983, Min 29, Max245, STD9.5013
>> Modified Min103, Max188
>> Final details- Mean154.7540, Min 31, Max242, STD8.9154
>> The image sg0002.bmp
>> is being processed. Kindly wait ...
>> Initial-  Mean 155.5076, Min 30, Max245, STD8.9303
>> Modified Min103, Max188
>> Final details- Mean155.0632, Min 33, Max242, STD8.2322
>>
>>
>> this is the info which i have to save on to an excel file, in different
>> columns with file name, respective mean, min, max etc
>>
>> is there any macro already existing so that i could absorb some motivation
>> from. kindly help
>>
>> thanks in advance
>>
>>
>
>
> --
>
> Damon Poburko, PhD
> Postdoctoral Research Fellow
> Stanford University School of Medicine
> Dept. of Molecular & Cellular Physiology
> 279 Campus Dr., Beckman B103, Stanford, CA 94305
> Ph: 650 725 7564, fax: [phone]
>

--
Donny George