Could you please comment on the following to let me know what it means. That will be a great help in understanding the code for me to experiment.
Code:
for i in $(tail -n+2 file.tmp | tr '\t' '\n' | sort -un)
do
tail -n+2 file.tmp | cut -f1 | grep -w $i 1>/dev/null 2>&1
let a=1-$?
To go one step ahead, in the output, how can I add another column lets say "e" after "d" which contains the sum of values in a, b, c and d. In other words, because 0 was present in all 4 initial columns in file.tmp, it got a value of 1(for existence) in all 4 output columns. How can I generate a column "e" which contains the sum of all these new entries, so inthe case of 0 I should get 4, and so on for the rest of the list.
I know I can do this in excel but I want to learn the command line for this.
Thanks a lot for the useful input.
Hello all,
Below is what I am trying to accomplish:
I have a file that looks like this
/* ----------------- xxxx.y_abcd_00000050 ----------------- */
jdghjghkla
sadgsdags
asdgsdgasd
asdgsagasdg
/* ----------------- xxxx.y_abcd_00000055 ----------------- */
sdgsdg
sdgxcvzxcbv... (8 Replies)
Hello. I have an RS/6000 running AIX 4 and I need to be able to see if there are any users that are logged on more than once from the same terminal so I can kick them off to make room for other terminals. 64 connections is the limit. Currently I am doing this:
who | more
and then manually... (11 Replies)
Hello,
I have a page where multiple fields and their values are displayed. But I am able to sort only a few fields. When I looked into the issue, it is seen that the for each row of info , an unique id is generated and id.txt is generated and saved. Only those fields which are inside that id.txt... (3 Replies)
Hi,
Let's say I have these 3 columns;
NGC1234 6 9
SL899 4 1
NGC1075 8 3
SL709 5 2
And I want to sort the data according to the first column (from a to z) like having them as:
NGC1075 8 3
NGC1234 6 9
SL709 5 2
SL899 4 1
Can that be done... (2 Replies)
Hello guys. I need help figuring this one out. It's probably really easy. Thanks in advance!
I have a file say for example containing this:
Rice Food
Carrots Food
Beans Food
Plates Kitchen
Fork Kitchen
Knives Kitchen
I need:
Food Rice, Carrots, Beans
Kitchen Plates, Fork,... (7 Replies)
My actual data looks like below
i have given only format. i can't give exact data format of my requirement due to some reasons. I this set of data lines about 5000
I need to come up with information in below
exact format of my data set :
Line<space>Number1<space>"somedata":... (1 Reply)
Hi,
PFB the data:
C_Random_130417
Java_Random_130518
Perl_Random_120519
Perl_Random_120528
so the values are ending with year,i.e.,130417
i want to sort the values with date.
i want the output like this:
Perl_Random_120519
Perl_Random_120528
C_Random_130417
Java_Random_130518
can... (5 Replies)
Hi Gurus,
I have a requests to sort data based on AS 400 sorting order. below is example: the data is sorted by ascending order. could anybody explain how AS 400 sort data?
IMM00007
07918607
1242
423 (3 Replies)
Discussion started by: green_k
3 Replies
LEARN ABOUT OSX
colrm
COLRM(1) BSD General Commands Manual COLRM(1)NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO awk(1), column(1), cut(1), paste(1)HISTORY
The colrm command appeared in 3.0BSD.
BSD August 4, 2004 BSD
03-15-2011
