[gradsusr] how to put the output numbers in an excel or a text file
Ricardo Hallak
hallak at model.iag.usp.br
Tue Feb 12 10:48:17 EST 2013
Dear T.,
test each variable value after capturing it with "subwrd(result,4)".
If the values appear on the terminal, they have to appear in the filename.txt too.
Anyway, if you still have problems with this, please, send me a copy of your script. Sometimes it is only a small detail.
Regards,
Ricardo
On Mon, 11 Feb 2013 18:32:52 +0000, T. haghroosta wrote
> Dear Ricardo,
>
> It works, but I have 10 oputputs and I tried your suggestion in this way:
>
> res=write('filename.txt', r1, r2, r3, r4, r5, f1, f2, f3 ,f4 ,f5 ,append)
>
> Which I used for all outputs the "subwrd(result,4)". The outputs are shown in the window, but the txt file just shows the r1 and f1! What is the problem?
>
> Regards,
>
> T.
>
>
> > ------------------------------
> >
> > Message: 8
> > Date: Mon, 11 Feb 2013 12:50:35 -0300
> > From: "Ricardo Hallak" <hallak at model.iag.usp.br>
> > Subject: Re: [gradsusr] how to put the output numbers in an excel or a
> > text file
> > To: GrADS Users Forum <gradsusr at gradsusr.org>
> > Message-ID: <20130211154118.M8968 at model.iag.usp.br>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Dear T.,
> > try this:
> >
> > 'reinit'
> >!; 'open E:\test.ctl'
> > 'set t 1'
> > 'set lat 10'
> > 'set lon 135'
> > 'define r1= sst'
> > 'set t 2'
> > 'set lat 20'
> > 'set lon 100'
> > 'define r2= sst'
> > 'define aver= (r1+r2)/2'
> > 'd aver'
> > newvar=subwrd(result,4)
> > res=write('filename.txt',newvar,append)
> > 'quit'
> >
> > Hope this helps.
> > Ricardo
> >
> > On Mon, 11 Feb 2013 13:04:58 +0000, T. haghroosta wrote
> > > ?
> > >
> > >
> > > Dear?All,
> > > ?
> > > I?wrote this script and I would like to see the amount of "aver" as an output in a .txt? or .xls file. Could you please help me?
> > > ?
> > > 'reinit'
> > > 'open E:\test.ctl'
> > > 'set t 1'
> > > 'set lat 10'
> > > 'set lon 135'
> > > 'define r1= sst'
> > > 'set t 2'
> > > 'set lat 20'
> > > 'set lon 100'
> > > 'define r2= sst'
> > > 'define av!er= (r1+r2)/2'
> > >
> > > ?Regards,
> > > ?
> > > T.
> > > ?
> > >
> > > > Dear All, I have a script to calculate the average of different groups of numbers. How can I show the outputs of the script running, contain numbers, in an excel or a text file? Regards, T.
> > > > -------------- next part --------------
> > > > An HTML attachment was scrubbed...
> > > > URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130208/ca3e352a/attachment-0001.html
> > > >
> > > > ------------------------------
> > > >
> > > > Message: 2
> > > > Date: Fri, 8 !Feb 2013 10:37:44 -0200
> > > > From: RafaelCB <rafael.ciram at gmail.com>
> > > > Subject: Re: [gradsusr] how put the output numbers in an excel or a
> > > > text file
> > > > To: GrADS Users Forum <gradsusr at gradsusr.org>
> > > > Message-ID:
> > > > <CAAgZ0pL8bQHs235nXYfTZzKJwEj1uPot9PrUbnz2!evQGQowCAA at mail.gmail.com>
> > > > Content-Type: text/plain; charset="iso-8859-1"
> > > >
> > > > An example follows:
> > > >
> > > > 'd gr2stn(rh.1,min.2)'
> > > > rh=sublin(result,_n2)
> > > > 'd gr2stn(u10.1,min.2)'
> > > > u1=sublin(result,_n2)
> > > > '!echo 'dia','hora','_sig','lo','la','rh','u1' | sed s@\ @@g >> verific.dat'
> > > >
> > > > I have helped.
> > > >
> > > > Regards.
> > > > --
> > > > *Rafael Censi Borges
> > > > Meteorologia - Epagri/Ciram
> > > > +55 (48)3665-5130
> > > > http://ciram.epagri.sc.gov.br*
> > > >
> > > >
> > > > 2013/2/8 T. haghroosta <haghroosta at hotmail.com>
> > > >
> > > > > Dear All,
> > > > >
> > > > &g!t; I have a script to calculate the average of differ!ent groups of numbers.
> > > > > How can I show the outputs of the script running, contain numbers, in an
> > > > > excel or a text file?
> > > > >
> > > > > Regards,
> > > > >
> > > > > T.
> > > > >
> > > > > _______________________________________________
> > > > > gradsusr mailing list
> > > > > gradsusr at gradsusr.org
> > > > > http://gradsusr.org/mailman/listinfo/gradsusr
> > > > >
> > > > >
> > > > -------------- next part --------------
> > > > An HTML attachment was scrubbed...
> > > > URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130208/d9812b61/attachment-0001.html
> > > >
> > > > ------------------------------
> > > >
> > > > _______________________________________________
> > > > gradsusr mailing list
> > > > gradsusr at gradsusr.org
> > > > http://gradsusr.!org/mailman/listinfo/gradsusr
> > > >
> > > >
> > > > End of gradsusr Digest, Vol 36, Issue 38
> > > > ****************************************
> > >
> >
> > Ricardo Hallak
> >
> > Departamento de Ci?ncias Atmosf?ricas (ACA)
> > Instituto de Astronomia, Geof?sica e Ci?ncias Atmosf?ricas (IAG)
> > Universidade de S?o Paulo (USP)
> > Rua do Mat?o, 1226 - Cidade Universit?ria - S?o Paulo SP 05508-900
> > Phone.: +55 (11) 3091-2850; 3091-4703
> > Fax: +55 (11) 3091-4714
> >
> >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130211/dee40dd3/attachment.html
> >
> > ------------------------------
> >
> > _______________________________________________
> > gradsusr mailing list
> > gradsusr at gradsusr.org
> > http://gradsusr.org/mailman/listinf!o/gradsusr
> >
> >
> > End of gradsusr Digest, Vol 36, Issue 41
> > ****************************************
Ricardo Hallak
Departamento de Ciências Atmosféricas (ACA)
Instituto de Astronomia, Geofísica e Ciências Atmosféricas (IAG)
Universidade de São Paulo (USP)
Rua do Matão, 1226 - Cidade Universitária - São Paulo SP 05508-900
Phone.: +55 (11) 3091-2850; 3091-4703
Fax: +55 (11) 3091-4714
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130212/8ec5ee6c/attachment-0003.html
More information about the gradsusr
mailing list