Hi forum, I am really hoping somebody can please help me here.
I have a dataset in xyz format, with longitude as x, latitude as y and data readings as z.
eg.
What i am looking to do is format the data so that x and y are untouched, however in z:
if z > 0 then ignore, else if z < 0 then add 20 to the z value
If anyone knows a better way to accomplish this than an awk command then feel free to contribute. I am very new to unix and am still learning the ropes.
I know the problem most people have in these posts is not conveying their question properly, so i hope mine is understood clearly.
Many thanks in advance, Sam.
Last edited by joeyg; 07-11-2012 at 01:43 PM..
Reason: Please wrap data and sripts with CodeTags
I have been searching around the forums here trying to find a solution to my problem but not getting anywhere but closer to baldness.
I have a 20 column pipe "|" seperated text file. The 14th variable doesnt always exist, but will have the format of YYYYMM or YYYY if it does.
I need to take... (2 Replies)
Hi all,
I need help manipulating the file below.
Here is what I needed to do.
First, I have to replace INSUPD to DELETE.
Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD")
How should I attack this?
Here... (2 Replies)
Hi,
I have two issues:
I have one file say file1.dat and its over 3GB. It contains pipe delimited fields. The first line in the file is the header field which tells the column names etc. and from second line it's the data fileds with pipe delimited. Something like below:
... (5 Replies)
Hi.
I am reasonably new to awk, but have done quite a lot of unix scripting in the past. I have resolved the issues below with unix scripting but it runs like a dog. Moved to awk for speed and functionality but running up a big learning curve in a hurry, so hope there is some help here.
I... (6 Replies)
Hi Guys,
Is there a simple way of doing the below.
Available<spaces>Assigned<spaces>Maximum<spaces>Maximum<spaces>Page<spaces>Total <spaces>Used<spaces>Pct<spaces>Max. Pct<CR>
Space<spaces>Capacity<spaces>Extension<spaces>Reduction<spaces>Size<spaces>... (8 Replies)
hi good day
I have a number of text files (xyz) that I want to format in to defined column widths (that is 7 digits (padding with zeros in cases where necessary) with 6 decimal places) using awk.
.
I can perform this on one text file at a time without any problems.
However I want to write a... (2 Replies)
Hi,
My variable has value as this:
tvar1="bool_risk_enabled" Boolean "true"
Now I need to replace this true with false. Which is the best way to do this? Can we do this with sed command?
Please help me.
---------- Post updated at 05:23 PM ---------- Previous update was at 05:00 PM... (2 Replies)
Hi everyone,
I have a little bit of complicated task to finish with AWK. Here it is;
I have a data file in xml format which looks like this
<data>
a1 a2 a3 a4 a5
b1 b2 b3 b4 b5
c1 c2 c3 c4 c5
d1 d2 d3 d4 d5
e1 e2 e3 e4 e5
</data>
lets say each data block contains 5 rows and 5 columns,... (13 Replies)
Discussion started by: hayreter
13 Replies
LEARN ABOUT DEBIAN
blockmode
BLOCKMODE(l) BLOCKMODE(l)
NAME
blockmode - filter to block average (x,y,z) data by mode estimation.
SYNOPSIS
blockmode [ xyz[w]file(s) ] -Ix_inc[m|c][/y_inc[m|c]] -Rwest/east/south/north[r] [ -C ] [ -F ] [ -H[nrec] ] [ -L ] [ -Q ] [ -V ] [ -W[io] ]
[ -: ] [ -bi[s][n] ] [ -bo[s][n] ]
DESCRIPTION
blockmode reads arbitrarily located (x,y,z) triples [or optionally weighted quadruples (x,y,z,w)] from standard input [or xyz[w]file(s)]
and writes to standard output mode estimates of position and value for every non-empty block in a grid region defined by the -R and -I
arguments. Either blockmean, blockmedian, or blockmode should be used as a pre-processor before running surface to avoid aliasing short
wavelengths. These routines are also generally useful for decimating or averaging (x,y,z) data. You can modify the precision of the output
format by editing the D_FORMAT parameter in your .gmtdefaults file, or you may choose binary input and/or output using single or double
precision storage.
xyz[w]file(s)
3 [or 4] column ASCII file(s) [or binary, see -b] holding (x,y,z[,w]) data values. [w] is an optional weight for the data. If no
file is specified, blockmode will read from standard input.
-I x_inc [and optionally y_inc] is the grid spacing. Append m to indicate minutes or c to indicate seconds.
-R west, east, south, and north specify the Region of interest. To specify boundaries in degrees and minutes [and seconds], use the
dd:mm[:ss] format. Append r if lower left and upper right map coordinates are given instead of wesn.
OPTIONS -C Use the center of the block as the output location [Default uses the modal xy location (but see -Q)]. -C overrides -Q.
-F Block centers have pixel registration. [Default: grid registration.] (Registrations are defined in GMT Cookbook Appendix B on grid
file formats.) Each block is the locus of points nearest the grid value location. For example, with -R10/15/10/15 and and -I1: with
the -F option 10 <= (x,y) < 11 is one of 25 blocks; without it 9.5 <= (x,y) < 10.5 is one of 36 blocks.
-H Input file(s) has Header record(s). Number of header records can be changed by editing your .gmtdefaults file. If used, GMT default
is 1 header record. Not used with binary data.
-L Indicates that the x column contains longitudes, which may differ from the region in -R by [multiples of] 360 degrees [Default
assumes no periodicity].
-Q (Quicker) Finds mode z and mean (x, y) [Default finds mode x, mode y, mode z].
-V Selects verbose mode, which will send progress reports to stderr [Default runs "silently"].
-W Weighted modifier[s]. Unweighted input and output has 3 columns x,y,z; Weighted i/o has 4 columns x,y,z,w. Weights can be used in
input to construct weighted modal values in blocks. Weight sums can be reported in output for later combining several runs, etc. Use
-W for weighted i/o, -Wi for weighted input only, -Wo for weighted output only. [Default uses unweighted i/o]
-: Toggles between (longitude,latitude) and (latitude,longitude) input/output. [Default is (longitude,latitude)]. Applies to geo-
graphic coordinates only.
-bi Selects binary input. Append s for single precision [Default is double]. Append n for the number of columns in the binary file(s).
[Default is 3 (or 4 if -W is set) columns].
-bo Selects binary output. Append s for single precision [Default is double].
EXAMPLES
To find 5 by 5 minute block mode estimates from the double precision binary data in hawaii_b.xyg and output an ASCII table, try
blockmode hawaii_b.xyg -R198/208/18/25 -I5m -bi3 > hawaii_5x5.xyg
SEE ALSO blockmean(1gmt), blockmedian(1gmt), gmt(1gmt), gmtdefaults(1gmt), nearneighbor(1gmt), surface(1gmt), triangulate(1gmt)
1 Jan 2004 BLOCKMODE(l)