02-23-2012
can you explain the below
I am trying to read each line individual from a file and want to know how many columns are just in that row and nothing else and when i loops around it read the next row and does the same thing
Please provide the sample input file and the output you needed.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file with the contents as below,
10:23:10 GOOD 10.30.50.60
10:23:11 GOOD 10.30.50.62
10:23:12 Hello 10.30.50.60
10:23:12 BAD 10.30.50.60
10:23:13 GOOD 10.30.50.66
10:23:14 BAD 10.30.50.62... (3 Replies)
Discussion started by: gobinath
3 Replies
2. Shell Programming and Scripting
Hi, i have data like
a
b
a
a
b
c
d
...
I have to output info of each distinct value that appears in the column and the count of it
a-3,b-2,c-1,d-1
Is there a single line command using awk or sed to accomplish this?
Thanks,
-srinivas yelamanchili (7 Replies)
Discussion started by: ysrini
7 Replies
3. Shell Programming and Scripting
Hi Guys,
B07 U51C A1 44 B1 44 Yes
B07 L64U A2 44 B1 44 Yes
B07 L62U A2 44 B1 44 Yes
B07 L11C A4 32 B1 44 NO
B05 L12Z A1 12 B1 44 NO
B01 651Z A2 44 B1 44 NO
B04 A51Z A2 12 B1 44 NO
L07 B08D A4 12 B1 44 NO
B07 RU8D A4 44 B1 44 Yes
B07 L58D A4 15 B1 44 No
B07 LA8D A4 44 B1 44 Yes
B07... (6 Replies)
Discussion started by: asavaliya
6 Replies
4. Shell Programming and Scripting
Need help on count
AL06 AL06_71 A=1 it=1 90
AL06 AL06_72 A=1 it=1 60
AL06 AL06_73 A=1 it=1 80
AL06 AL06_7 A=2 it=1 0
AL06 AL06_7 A=2 it=1 0
AL06 AL06_7 A=2 it=1 0
AL07 AL07_71 A=1 it=1 40
AL07 AL07_72 A=1 it=1 40
AL07 AL07_73 A=1 it=1 70
AL08 AL08_7 A=2 it=1 0 1
AL08 AL08_7 A=2 it=1... (2 Replies)
Discussion started by: asavaliya
2 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I have file like this:
FID IID MISS_PHENO N_MISS N_GENO F_MISS
AU4103 AU4103201 Y 15473 66858 0.2314
AU4142 AU4142303 Y 15464 66858 0.2313
AU4128 AU4128304 Y 15458 66858 0.2312
AU4129 AU4129202 Y 15451 66858 0.2311
AU3934 AU3934201 Y 15441 66858 0.231
AU3934 AU3934304 Y 15448 66858... (2 Replies)
Discussion started by: luoruicd
2 Replies
6. Shell Programming and Scripting
HI Guys,
Count base on column A
Input:-
U00393 6 000100000
U00393 7 000100001
U00393 8 000100002
U00393 9 000100003
U00393 10 000100004
U00393 11 000100005
U00928 6 000100000
U00928 7 000100001
U00964 6 000100000
U00964 7 000100001
U00964 8 000100002
U00972 6 000100000
U00972... (3 Replies)
Discussion started by: asavaliya
3 Replies
7. UNIX for Dummies Questions & Answers
how do i count column in a file.
test1,test2,test3,,, = 5 columns (6 Replies)
Discussion started by: lawsongeek
6 Replies
8. Shell Programming and Scripting
Hello
How can I get a number of occurrence count for this file;
ERR315389.1000156 CTTGAAGAAGAATTGAAAACTGTGACGAACAACTTGAAGTCACTGGAGGCTCAGGCTGAGAAGTACTCGCAGAAGGAAGACAGATATGAGGAAGAG
ERR315389.1000281 ... (3 Replies)
Discussion started by: Wan Fahmi
3 Replies
9. Shell Programming and Scripting
Hello all,
I would like to ask your help here:
I've a huge file that has 2 columns. A part of it is:
sorted.txt:
kss23 rml.67lkj
kss23 zhh.6gf
kss23 nhd.09.fdd
kss23 hp.767.88.89
fl67 nmdsfs.56.df.67
fl67 kk.fgf.98.56.n
fl67 bgdgdfg.hjj.879.d
fl66 kl..hfh.76.ghg
fl66... (5 Replies)
Discussion started by: Padavan
5 Replies
10. Shell Programming and Scripting
My I/p is
Col1|Col2|Col3
2116209997932|POSIX INC|POSIX
2116209997933|POSIX INC|POSIX
2116210089479|POSIX INC|POSIX
2116210180502|POSIX INC|POSIX
2116210512279|POSIX INC|Aero
2116210516838|POSIX INC|POSIX
2116210534342|POSIX INC|postal
2116210534345|POSIX INC|postal ... (6 Replies)
Discussion started by: nikhil jain
6 Replies
PSC(1) General Commands Manual PSC(1)
NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS
-f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO
sc(1)
AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)