I have a large tab delimited text file with 10 columns
for example
Code:
chrM 412 A A 75 0 25 2 ..,AGAATt II
chrM 413 G G 72 0 25 4 ..t,,Aag IIIH
chrM 414 C C 75 0 25 4 ...a,.. III2
chrM 415 C T 75 75 25 4 TTTt,,,ATC III7
At column 9, I want to count the occurrence of each of the character. The characters I need to count for each line is .(point) , (comma), A/a, T/t, C/c, G/c.
So that I could get a file as below.
Code:
value at column 2 Count of "." Count of "," Count of "A/a" Count of "G/g" Count of "C/c" Count of "T/t"
412 2 1 3 1 0 2
413 2 2 2 1 0 1
414
415
...
....
.....
for all the numbers in column 2 of the input file
Please let me know the best way to do this using awk or sed.
Hi all. If I have a unix directory with multiple files, lets say, I have some with .dat extensions, some with .txt extensions, etc etc.
How in a script would I provide a count of all the different file types (so, the different extensions, I guess) in the directory??
So if I had:
test.dat... (6 Replies)
I need "awk solution" for simple counting!
File looks like:
STUDENT GRADE
student1 A
student2 A
student3 B
student4 A
student5 B
Desired Output:
GRADE No.of Students
A 3
B 2
Thanks for awking! (4 Replies)
my script:
count=0while test $count -lt 10do#do something for 0,1,2...9 count=$(($count+1))doneIt doesnt work. Can anyone tell me what im doing wrong?? thanks (11 Replies)
Hi,
I want to count how many rows are in a file for a specific column.
eg.
K NM
K NM
K NM
K JK
K NM
K JK
K NM
so the file is tab-delimited. I want to count how many rows are in column 2 and how many NMs there are.
I used awk
awk '{OFS="\t"}; {count++} {print i,... (3 Replies)
Hi,
The following output shows how many pmon process are started by users named : oracle or yoavb
$ ps -ef |grep pmon |grep -v grep |grep -v ipmon
oracle 11268 1 0 Sep 2 ? 36:00 ora_pmon_qerp
oracle 17496 1 0 Oct 11 ? 8:58 ora_pmon_bcv
oracle 15081 1 0 ... (5 Replies)
I’m new to Linux script and not sure how to filter out bad records from huge flat files (over 1.3GB each). The delimiter is a semi colon “;”
Here is the sample of 5 lines in the file:
Name1;phone1;address1;city1;state1;zipcode1
Name2;phone2;address2;city2;state2;zipcode2;comment... (7 Replies)
Hi all,
I promise this is my very last dumb question.. but how to you count how many unique names you have.
My dataset is:
>Bac1
afdsgrr
>Bac4
egege
>Bac8
dgrjh
>Bac1
afdsgrr
>Bac1
afdsgrr
>Bac8
dgrjh
What i want to know is that how many unique names there is, so the output would... (3 Replies)
TABS(1) BSD General Commands Manual TABS(1)NAME
tabs -- set terminal tabs
SYNOPSIS
tabs [-n | -a | -a2 | -c | -c2 | -c3 | -f | -p | -s | -u] [+m[n]] [-T type]
tabs [-T type] [+[n]] n1[,n2,...]
DESCRIPTION
The tabs utility displays a series of characters that clear the hardware terminal tab settings then initialises tab stops at specified posi-
tions, and optionally adjusts the margin.
In the first synopsis form, the tab stops set depend on the command line options used, and may be one of the predefined formats or at regular
intervals.
In the second synopsis form, tab stops are set at positions n1, n2, etc. If a position is preceded by a '+', it is relative to the previous
position set. No more than 20 positions may be specified.
If no tab stops are specified, the ``standard'' UNIX tab width of 8 is used.
The options are as follows:
-n Set a tab stop every n columns. If n is 0, the tab stops are cleared but no new ones are set.
-a Assembler format (columns 1, 10, 16, 36, 72).
-a2 Assembler format (columns 1, 10, 16, 40, 72).
-c COBOL normal format (columns 1, 8, 12, 16, 20, 55)
-c2 COBOL compact format (columns 1, 6, 10, 14, 49)
-c3 COBOL compact format (columns 1, 6, 10, 14, 18, 22, 26, 30, 34, 38, 42, 46, 50, 54, 58, 62, 67).
-f FORTRAN format (columns 1, 7, 11, 15, 19, 23).
-p PL/1 format (columns 1, 5, 9, 13, 17, 21, 25, 29, 33, 37, 41, 45, 49, 53, 57, 61).
-s SNOBOL format (columns 1, 10, 55).
-u Assembler format (columns 1, 12, 20, 44).
+m[n], +[n]
Set an n character left margin, or 10 if n is omitted.
-T type
Output escape sequence for the terminal type type.
ENVIRONMENT
The LANG, LC_ALL, LC_CTYPE and TERM environment variables affect the execution of tabs as described in environ(7).
The -T option overrides the setting of the TERM environment variable. If neither TERM nor the -T option are present, tabs will fail.
EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs.
SEE ALSO expand(1), stty(1), tput(1), unexpand(1), termcap(5)STANDARDS
The tabs utility conforms to IEEE Std 1003.1-2001 (``POSIX.1'').
HISTORY
A tabs utility appeared in PWB UNIX. This implementation was introduced in FreeBSD 5.0.
BUGS
The current termcap(5) database does not define the 'ML' (set left soft margin) capability for any terminals.
BSD May 20, 2002 BSD