10 More Discussions You Might Find Interesting
1. Programming
The file is similar to the attached.
Thousands of columns, delimiter is tab, with many columns containing free text and space separated.
I want to get the count of columns with non-empty entries.
eg.Col1=10, Col6=5, Col8=1
awk preferred (7 Replies)
Discussion started by: genehunter
7 Replies
2. UNIX for Beginners Questions & Answers
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
3. UNIX for Beginners Questions & Answers
Hello, I have two tab files with headers
File1: with 4 columns
header1 header2 header3 header4
44 a bb 1
57 c ab 4
64 d d 5
File2: with 26 columns
header1.. header5 header6 header7 ... header 22...header26
id1 44 a bb
id2 57 ... (6 Replies)
Discussion started by: nans
6 Replies
4. Shell Programming and Scripting
Hi Friends,
I have an input file like this
chr1 100 200 1 2 3 4
chr1 150 200 4 5 6 7
chr2 300 400 9 6 7 1
chr2 300 410 -10 21 -11 13
chr3 700 900 -21 -22 130 165
Now, my output file is
chr1 100 200 1
chr1 150 200 4
chr2 300 400 1
chr2 300 410 10
chr3 700 900 21
Remove... (5 Replies)
Discussion started by: jacobs.smith
5 Replies
5. Shell Programming and Scripting
Hi Friends,
my input file is this way
chr1 100 120 abc
chr1 100 121 def
chr1 100 122 ghi
chr2 240 263 kil
chr2 240 276 ghj
chr2 255 290 hjh
my output
chr1 100 122 abc
chr2 240 276 kil
chr2 255 290 hjh
Basically, I want to match on first and second column and then print the... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a file like:
0.000000 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 33.097845 33.363764
0.000000 266.483441 262.519130 266.380993 274.989622 289.594799 309.523518 336.124848 372.386124 413.522043 429.984825 421.621810... (6 Replies)
Discussion started by: cosmologist
6 Replies
7. Shell Programming and Scripting
hi I am very new to shell scripting. i wanted to achieve this..
Col1 Col2 Col3 Col4
aa 23 bb 32
aa 34 bb 12
aa 45 bb 345
kk 20 ss 50
kk 30 ss 50
tt 10 vv 50
Desired output is
Col1 Col2 Col3 Col4 Difference Count
aa 23 bb ... (1 Reply)
Discussion started by: empyrean
1 Replies
8. Shell Programming and Scripting
Hi,
I have a file where i have dump of a DB. it has all the columns and rows inside that. I wanted to extract the columns and number of columns from that dump.
Any suggestions will be helpful.
Thanks (1 Reply)
Discussion started by: namishtiwari
1 Replies
9. UNIX for Dummies Questions & Answers
Hi.
I would like to ask for helps on extracting a minimum values among three columns using gawk in tab separator.
input file:
as1 10 20 30
as2 22 21 23
as3 300 391 567
as4 19 20 15
Output file:
as1 10
as2 21
as3 300
as4 15
I am extremely appreciate your helps and comments.... (2 Replies)
Discussion started by: Amanda Low
2 Replies
10. Shell Programming and Scripting
I'm writting a script that will get the logical volumes from a volume group and check for mirroring. I'm using a while read line command. I need to be able to count the columns for the output and if it is <= 3 save the logical volume to a file and if it is > 3 continue. How do I capture the... (1 Reply)
Discussion started by: daveisme
1 Replies