<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
need to read tables with blank spaces like the one below. <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Is there any easier way to read this table without manually inserting some dummy values in the blank space?
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<img style="max-width: 100%; width: 918px; height: 268.132px;" size="106547" contenttype="image/png" width="918" height="268" data-outlook-trace="F:1|T:1" src="cid:430a5345-b411-4159-b0a5-f2f78a07ecf2"></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks a lot!</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Xiaoming Hu <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> ncl-talk <ncl-talk-bounces@ucar.edu> on behalf of xiaoming Hu <yuanfangcan@hotmail.com><br>
<b>Sent:</b> Tuesday, April 9, 2019 4:52 PM<br>
<b>To:</b> Dennis Shea <shea@ucar.edu><br>
<b>Cc:</b> Ncl-talk <ncl-talk@ucar.edu>; Xiaoming Hu <xhu@ou.edu><br>
<b>Subject:</b> Re: [ncl-talk] readAsciiTable to handle ***** in data</font>
<div> </div>
</div>
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Dennis</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Thank you so much! I agree "<span style="color:rgb(33,33,33); font-size:15px; background-color:rgb(255,255,255); display:inline!important">Likely, a fortran code with f4.1 was used but should have been f5.1</span>". </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
You code is really helpful: </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span> ndat = numAsciiRow(pthtxt)<br>
</span>
<div> ncol = numAsciiCol(pthtxt)<br>
</div>
<div> print("ndat="+ndat+"; ncol="+ncol)<br>
</div>
<div><br>
</div>
<div> dstr = asciiread(pthtxt, -1, "string")<br>
</div>
<div> dstr := str_sub_str(dstr,"*****","999.9") ; change<br>
</div>
<div> print(dstr)<br>
</div>
<div><br>
</div>
<div> delim = " "<br>
</div>
<div> id = str_get_field(dstr, 1, delim) ; toint(str_get_field(dstr, 1, delim) )<br>
</div>
<div><br>
</div>
<div> col27 = tofloat( str_get_field(dstr,27, delim) )<br>
</div>
<div> col28 = tofloat( str_get_field(dstr,28, delim) )<br>
</div>
<div><br>
</div>
<div> col27 = where(col27.eq.999.9, 99999.0, 88888.0) ; whatever you wany<br>
</div>
<div> i9999 = ind(.not.(col28.eq.999.9)) ; rows/line where a 999.9 does not appear<br>
</div>
<div><br>
</div>
<div> print(id+" "+col27+" "+col28)<br>
</div>
<span></span><br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Xiaoming </div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<br>
</div>
</body>
</html>