Dear All,
I have some flat archives which contain dummy (-9999), Blank ( ) and Dash
(-) inserts. Explanations for these bizarre inserts are: "Where data are
missing or deleted, a marker value of -9999 is inserted. Zero values are
left blank. Negative values rounded to zero are "-". Now, I want to make a
GDB out of this flat archives (I have quit many of them in large
sizes!!!!!.) and replace blank and "-" characters with "zero" values. Does
any one know a simple/quick way of doing this? I can't send any attachment
using GEONET. However I have digital versions of the sample flat archive and
the "i3" template (PKZipped size: 12KB) if you are interested in receiving
and trying out - Just drop a line and ask! I will send it to your personal
mail address.
Good weekend every one,
mansour shoari
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Specifying Double format in the .i3 file wouldn't work because of dash
inserts (-). Specifying ASCII would treat the column(s) as "string" type and
would bring everything into the GDB as is, including -9999 values - this
template created blank blank cells (not with "*" char.) and ignore the
specified scale as well.
Herewith is the shortened version of the flat archive plus the i3 template:
20011 11931102 4076700 36504 4104624 71717512 2080 -9999 56
-9 11 33 - -61 -50 2 -214 13 -232 113 3027
-9999 3664 44350
20011 11931102 4076720 -9999 4104626 71717592 2080 594432 62
-7 12 33 33 -63 -55 2 -216 11 - 103 3027
-9999 3664 44660
20011 11931102 4076739 37007 4104627 71717672 2080 594489 -
-5 12 38 -67 -1 -58 1 -214 10 -255 98 3027
-9999 3664 44820
20011 11931102 4076759 37014 4104629 71717752 2080 594525 71
-3 11 16 41 -71 - -59 -214 8 -255 97 3027
-9999 3664 44850
20011 11931102 4076779 37021 4104631 71717832 2080 -9999 68
-2 10 12 44 -72 -1 -59 - -215 8 -254 93 3027
-9999 3664 44990
20012 11931102 4076799 37029 4104632 71717912 2070 594542 56
-1 10 6 45 -59 -216 10 -258 83 3027
-9999 3664 45360
20012 11931102 4076819 -9999 4104634 71717992 2070 594526 -
-2 9 1 - -71 -2 -59 -216 9 - 81 3027
-9999 3664 45440
20012 11931102 4076839 37043 4104635 71718072 2070 -9999 21
-3 8 -2 45 -1 -59 -210 8 -249 84 3027
-9999 3664 45320
20012 11931102 4076859 37050 4104637 71718152 2060 594456 -17
-5 - -6 44 -71 -59 - -203 8 -241 86 3027
-9999 3664 45250
20012 11931102 4076879 37058 4104638 71718232 2060 594411 -44
-8 8 -9 42 -70 -58 - -195 8 -233 87 3027
-9999 3664 45210
20013 11931102 4076899 37065 4104640 71718312 2050 594367 -70
-11 7 -10 40 -1 -58 -185 9 86 3027
-9999 3664 45250
20013 11931102 4076919 -9999 4104642 71718392 2050 -9999 -
-15 7 -10 - -72 -2 -60 - -178 9 -218 80 3027
-9999 3664 45480
20013 11931102 4076939 37079 4104643 71718472 2050 594316 -105
-20 7 -10 32 -74 -1 -62 -176 10 -218 82 3027
-9999 3664 45400
20013 11931102 4076959 37086 4104645 71718552 2050 594325 -106
-24 7 -8 26 -74 -2 -63 - -187 10 -226 91 3027
-9999 3664 45060
20013 11931102 4076979 37094 4104646 71718632 2050 594362 -79
-30 6 -6 20 -76 -2 -63 -211 10 -239 89 3027
-9999 3664 45130
[IMPORT ARCHIVE]
FILEHEADER 0
RECORDFORM FIXED
SKIPSTRING "/"
LINENUMBER 0,8,NORMAL
DATA 8,3,NORMAL,,,-9999,
CHAN FLT,ASCII,NORMAL,3,0
DATA 11,6,NORMAL,,,-9999,
CHAN DATE,ASCII,NORMAL,6,0
DATA 17,8,NORMAL,,,-9999,
CHAN TIME,ASCII,NORMAL,8,0
DATA 25,9,NORMAL,0.001,,-9999,
CHAN FIDUCIAL,ASCII,NORMAL,9,0
DATA 34,9,NORMAL,0.1,,-9999,
CHAN X,ASCII,NORMAL,9,0
DATA 43,9,NORMAL,0.1,,-9999,
CHAN Y,ASCII,NORMAL,9,0
DATA 52,6,NORMAL,0.1,,-9999,
CHAN RALT,ASCII,NORMAL,6,0
DATA 58,7,NORMAL,0.01,,-9999,
CHAN LEV_TMI,ASCII,NORMAL,7,0
DATA 65,6,NORMAL,0.1,,-9999,
CHAN CVG1,ASCII,NORMAL,6,0
DATA 71,6,NORMAL,0.1,,-9999,
CHAN VLF_TF_L,ASCII,NORMAL,6,0
DATA 77,6,NORMAL,0.1,,-9999,
CHAN VLF_Q_L,ASCII,NORMAL,6,0
DATA 83,6,NORMAL,0.1,,-9999,
CHAN VLF_TF_O,ASCII,NORMAL,6,0
DATA 89,6,NORMAL,0.1,,-9999,
CHAN VLF_Q_O,ASCII,NORMAL,6,0
DATA 95,6,NORMAL,0.1,,-9999,
CHAN LOWCX_I,ASCII,NORMAL,6,0
DATA 101,6,NORMAL,0.1,,-9999,
CHAN LOWCX_Q,ASCII,NORMAL,6,0
DATA 107,6,NORMAL,0.1,,-9999,
CHAN MIDCX_I,ASCII,NORMAL,6,0
DATA 113,6,NORMAL,0.1,,-9999,
CHAN MIDCX_Q,ASCII,NORMAL,6,0
DATA 119,6,NORMAL,0.1,,-9999,
CHAN MIDCP_I,ASCII,NORMAL,6,0
DATA 125,6,NORMAL,0.1,,-9999,
CHAN MIDCP_Q,ASCII,NORMAL,6,0
DATA 131,6,NORMAL,0.1,,-9999,
CHAN HICP_I,ASCII,NORMAL,6,0
DATA 137,6,NORMAL,0.1,,-9999,
CHAN HICP_Q,ASCII,NORMAL,6,0
DATA 143,6,NORMAL,0.001,,-9999,
CHAN RESLOWCX,ASCII,NORMAL,6,0
DATA 149,6,NORMAL,0.001,,-9999,
CHAN RESMIDCX,ASCII,NORMAL,6,0
DATA 155,6,NORMAL,0.001,,-9999,
CHAN RESMIDCP,ASCII,NORMAL,6,0
DATA 161,7,NORMAL,0.001,,-9999,
CHAN RESHICP,ASCII,NORMAL,7,0
_______________________________________________________
More mailing list info http://www.geosoft.com/support/listserv/index.html
