<html><body><div style="color:#000; background-color:#fff; font-family:garamond, new york, times, serif;font-size:16px"><div><span></span></div><div></div><div id="yui_3_16_0_1_1418809253311_6889" dir="ltr">Thank you very much, I know my problem, the problem I am facing is to import space delimited data into single column in excel. I think I need to find out how to overcome this problem. I did as you instructed but still when I open in excel I get many columns</div><div id="yui_3_16_0_1_1418809253311_6890" dir="ltr"><br></div><div id="yui_3_16_0_1_1418809253311_6866"><div id="yui_3_16_0_1_1418809253311_6865">AS EVER
<br>LUHUNGA
<br>
<br>--------------------
<br>Philbert Modest Luhunga
<br>University of Pretoria
<br>Department of Geography,Geoinformatics and Meteorology
<br>Private Bag X20 Hatfield 0028 South Africa
<br>Tel +27 (0) 12 420 5164
<br>Fax +27 (0) 12 420 6385
<br>Mobile:+ 27826228060
<br>Email address: philuhunga@yahoo.com</div></div><br> <div id="yui_3_16_0_1_1418809253311_6894" style="font-family: garamond, new york, times, serif; font-size: 16px;"> <div id="yui_3_16_0_1_1418809253311_6893" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1418809253311_6892" dir="ltr"> <hr size="1"> <font id="yui_3_16_0_1_1418809253311_6891" face="Arial" size="2"> <b><span style="font-weight: bold;">From:</span></b> Lyndon Mark Olaguera <olagueralyndonmark429@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> GrADS Users Forum <gradsusr@gradsusr.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, December 16, 2014 10:01 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [gradsusr] Extract values from all grid points in a domain<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1418809253311_6904"><br><div id="yiv0593566100"><div id="yui_3_16_0_1_1418809253311_6903"><div dir="ltr">Hi,<div><br clear="none"></div><div>It is possible to output it in one column.</div><div>Try using the following command.</div><div>'<a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a> [variable to be extracted][you can add a date string here].csv%g 0'</div><div><br clear="none"></div><div>In my case, I read a txtfile containing the names of the stations and the grads script read the txt file line by line.</div><div>So the output of the <a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a> will have the station name (look at the example belew: 'stn'). You can also use a datestring if you want to separate the outputs per day or per month etc.</div><div><br clear="none"></div><div>Example:</div><div>'<a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a> rainc+rainnc hourlyrain_5days/Thompson/'stn'_WSM6.csv %g 0'<br clear="none"></div></div><div class="yiv0593566100gmail_extra" id="yui_3_16_0_1_1418809253311_6902"><br clear="all"><div id="yui_3_16_0_1_1418809253311_6901"><div class="yiv0593566100gmail_signature" id="yui_3_16_0_1_1418809253311_6900"><div id="yui_3_16_0_1_1418809253311_6899" dir="ltr"><font id="yui_3_16_0_1_1418809253311_6898" face="comic sans ms, sans-serif"><i id="yui_3_16_0_1_1418809253311_6897"><b id="yui_3_16_0_1_1418809253311_6896"><u id="yui_3_16_0_1_1418809253311_6895">Lyndon Mark P. Olaguera</u></b></i></font><div><font face="comic sans ms, sans-serif">Assistant Instructor</font></div><div><font face="comic sans ms, sans-serif">Ateneo de Manila University</font></div><div><font face="comic sans ms, sans-serif">426 6001</font></div><div><font face="comic sans ms, sans-serif">loc 5695</font></div></div></div></div>
<br clear="none"><div class="yiv0593566100gmail_quote">On Mon, Dec 15, 2014 at 6:04 PM, PHILBERT LUHUNGA <span dir="ltr"><<a href="mailto:philuhunga@yahoo.com" target="_blank" rel="nofollow" shape="rect" ymailto="mailto:philuhunga@yahoo.com">philuhunga@yahoo.com</a>></span> wrote:<blockquote class="yiv0593566100gmail_quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;"><br clear="none">
<br clear="none">
Hi thank you very much, if <a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a>,prec prec.txt, I get text file, when this file opened in excel, it open in several column, say column A, B,C, D, E, F, G, H........<br clear="none">
so to make it one column I cut all other column and paste on column A, is it fine to do this or do you know any method when I fprintf. Variable I can get file when opened in excel open in one column??. Thank you for your help<br clear="none">
<br clear="none">
<br clear="none">
------------------------------<br clear="none">
<span class="yiv0593566100">On Sun, Dec 14, 2014 4:34 PM PST Lyndon Mark Olaguera wrote:<br clear="none">
<br clear="none">
>Hello,<br clear="none">
>I did not print the time variable. If you know the time step of your data<br clear="none">
>as well as the starting and end times, you can manually put the time<br clear="none">
>variable in the output of the <a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a>.<br clear="none">
><br clear="none">
><br clear="none">
</span>>*Lyndon Mark P. Olaguera*<br clear="none">
<div class="yiv0593566100HOEnZb"><div class="yiv0593566100h5">>Assistant Instructor<br clear="none">
>Ateneo de Manila University<br clear="none">
>426 6001<br clear="none">
>loc 5695<br clear="none">
><br clear="none">
>On Sun, Dec 14, 2014 at 4:32 AM, PHILBERT LUHUNGA <<a href="mailto:philuhunga@yahoo.com" target="_blank" rel="nofollow" shape="rect" ymailto="mailto:philuhunga@yahoo.com">philuhunga@yahoo.com</a>><br clear="none">
>wrote:<br clear="none">
>><br clear="none">
>><br clear="none">
>><br clear="none">
>> hi Lyndon did you manage to <a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a> time variable?? , how did you do it<br clear="none">
>><br clear="none">
>><br clear="none">
>> ------------------------------<br clear="none">
>> On Fri, Dec 12, 2014 8:20 PM PST Lyndon Mark Olaguera wrote:<br clear="none">
>><br clear="none">
>> >Hi All,<br clear="none">
>> ><br clear="none">
>> >I'd like to extract data values from all the gridpoints in a domain. How<br clear="none">
>> >can I do this in GRADS?<br clear="none">
>> >Before I used the <a href="http://fprintf.gs/" target="_blank" rel="nofollow" shape="rect">fprintf.gs</a> to extrac values from specific gridpoints.<br clear="none">
>> >Any suggestion?<br clear="none">
>> ><br clear="none">
>> ><br clear="none">
>> ><br clear="none">
>> >*Lyndon*<br clear="none">
>><br clear="none">
>> _______________________________________________<br clear="none">
>> gradsusr mailing list<br clear="none">
>> <a href="mailto:gradsusr@gradsusr.org" target="_blank" rel="nofollow" shape="rect" ymailto="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br clear="none">
>> <a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank" rel="nofollow" shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><div class="qtdSeparateBR"><br><br></div><div class="yiv0593566100yqt3064445177" id="yiv0593566100yqtfd28987"><br clear="none">
>><br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
gradsusr mailing list<br clear="none">
<a href="mailto:gradsusr@gradsusr.org" target="_blank" rel="nofollow" shape="rect" ymailto="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br clear="none">
<a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank" rel="nofollow" shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><br clear="none">
</div></div></div></blockquote></div></div></div></div><br><div class="yqt3064445177" id="yqtfd18927">_______________________________________________<br clear="none">gradsusr mailing list<br clear="none"><a href="mailto:gradsusr@gradsusr.org" shape="rect" ymailto="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br clear="none"><a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank" shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><br clear="none"></div><br><br></div> </div> </div> </div></body></html>