Assuming that data values are strings (not numbers that need to be converted to a canonical format), and that you want a count of the number of times a string appears in your input file, the following awk script seems to come close to what you said you wanted:
producing the following output from your sample data:
(although if I were specifying the output format I'd put spaces around the equal signs and before the "time" in the secondary output.
As always, if you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
This User Gave Thanks to Don Cragun For This Post:
Hi Guys...
I am newbie to awk and would like a solution to probably one of the simple practical questions.
I have a test file that goes as:
1,2,3,4,5,6
7,2,3,8,7,6
9,3,5,6,7,3
8,3,1,1,1,1
4,4,2,2,2,2
I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Hello,
I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file.
For example:
File 1 has 1411 rows, I ignore how many columns it has (thousands)
File 2 has 311 rows, 1 column
Would like to... (7 Replies)
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
I am a new user of Unix/Linux, so this question might be a bit simple!
I am trying to join two (very large) files that both have different # of cols and rows in each file.
I want to keep 'all' rows and 'all' cols from both files in the joint file, and the primary key variables are in the rows.... (1 Reply)
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Hi. How can I read row number from one file and print that corresponding record present at that row in another file.
eg
file1
1
3
5
7
9
file2
11111
22222
33333
44444
55555
66666
77777
88888
99999 (3 Replies)
I need help with extract/print lines till stop pattern. This needs to happen after every 3rd occurrence of start pattern and continue till end of file. Consider below is an example of the log file. my start pattern will be every 3rd occurrence of ERROR_FILE_NOT_FOUND and stop pattern will be... (5 Replies)
Hi Gurus,
I have requirement to identify the records based on one column value.
the sample file as below:
ID AMT, AMT1
100,10, 2
100,20, 3
200,30, 0
200, 40, 0
300, 20, 2
300, 50, 2
400, 20, 1
400, 60, 0
for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add... (5 Replies)
Discussion started by: ken6503
5 Replies
LEARN ABOUT SUNOS
overlay
overlay(3XCURSES) X/Open Curses Library Functions overlay(3XCURSES)NAME
overlay, overwrite - copy overlapped windows
SYNOPSIS
cc [ flag... ] file... -I /usr/xpg4/include -L /usr/xpg4/lib
-R /usr/xpg4/lib -lcurses [ library... ]
c89 [ flag... ] file... -lcurses [ library... ]
#include <curses.h>
int overlay(const WINDOW *srcwin, WINDOW *dstwin);
int overwrite(const WINDOW *srcwin, WINDOW *dstwin);
PARAMETERS
srcwin Is a pointer to the source window to be copied.
dstwin Is a pointer to the destination window to be overlayed or overwritten.
DESCRIPTION
The overwrite() and overlay() functions overlay srcwin on top of destwin. The srcwin and dstwin arguments do not have to be the same size;
only text where the two windows overlap is copied.
The overwrite() function copies characters as though a sequence of win_wch(3XCURSES) and wadd_wch(3XCURSES) were performed with the desti-
nation window's attributes and background attributes cleared.
The overlay() function does the same thing, except that, whenever a character to be copied is the background character of the source win-
dow, overlay() does not copy the character but merely moves the destination cursor the width of the source background character.
If any portion of the overlaying window border is not the first column of a multi-column character, then all the column positions will be
replaced with the background character and rendition before the overlay is done. If the default background character is a multi-column
character when this occurs, then these functions fail.
RETURN VALUES
Upon successful completion, these functions return OK. Otherwise, they return ERR.
ERRORS
No errors are defined.
EXAMPLES
Example 1: Implement a pop-up dialog
The following example demonstrates the use of overwrite() to implement a pop-up dialog box.
#include <curses.h>
/*
* Pop-up a window on top of curscr. If row and/or col
* are -1 then that dimension will be centered within
* curscr. Return 0 for success or -1 if malloc() failed.
* Pass back the working window and the saved window for the
* pop-up. The saved window should not be modified.
*/
int
popup(work, save, nrows, ncols, row, col)
WINDOW **work, **save;
int nrows, ncols, row, col;
{
int mr, mc;
getmaxyx(curscr, mr, mc);
/* Windows are limited to the size of curscr. */
if (mr < nrows)
nrows = mr;
if (mc < ncols)
ncols = mc;
/* Center dimensions. */
if (row == -1)
row = (mr-nrows)/2;
if (col == -1)
col = (mc-ncols)/2;
/* The window must fit entirely in curscr. */
if (mr < row+nrows)
row = 0;
if (mc < col+ncols)
col = 0;
*work = newwin(nrows, ncols, row, col);
if (*work == NULL)
return (-1);
if ((*save = dupwin(*work)) == NULL) {
delwin(*work);
return (-1);
}
overwrite(curscr, *save);
return(0);
}
/*
* Restore the region covered by a pop-up window.
* Delete the working window and the saved window.
* This function is the complement to popup(). Return
* 0 for success or -1 for an error.
*/
int
popdown(work, save)
WINDOW *work, *save;
{
(void) wnoutrefresh(save);
(void) delwin(save);
(void) delwin(work);
return(0);
}
/*
* Compute the size of a dialog box that would fit around
* the string.
*/
void
dialsize(str, nrows, ncols)
char *str;
int *nrows, *ncols;
{
int rows, cols, col;
for (rows = 1, cols = col = 0; *str != '