10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Does anyone know of an efficient way to index a column of data in file2 to print the coresponding row in file1 which corresponds to the data in file2 AND 30 rows preceding and after the row in file1.
For example suppose you have a list of numbers in file2 (single column) as follows:... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
2. UNIX for Beginners Questions & Answers
Dear All,
I have a data file input.res like below. (Only six column shown here for example.)
Sequence of first column starting from 1 to 148.
Input file
1 Q0 9_August_2014_Entertainment2 0 20.14967806339729 BM25b1.0
1 Q0 13_October_2012_Page323 1 20.134224346765738 BM25b1.0
1 Q0... (2 Replies)
Discussion started by: imranrasheedamu
2 Replies
3. Shell Programming and Scripting
I tried this. It working fine for small tables. But it is giving values greater than zero in a big file with 8556 columns. Does any one know why ?
awk 'FNR == 1{print;next}{for(i=8556;i<=NF;i++) if($i <= 0){print;next}}' input (5 Replies)
Discussion started by: quincyjones
5 Replies
4. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. UNIX for Dummies Questions & Answers
First time poster, but the forum has saved my bacon more times than... Lots.
Anyway, I have a text file, and wanted to use Awk (or any other sensible program) to print out overlapping sections, or arbitrary length. To describe by example, for file
1
2
3
4
5
etc...
I want the out put... (3 Replies)
Discussion started by: matfald
3 Replies
6. Shell Programming and Scripting
Hi,
I have two files Input1.txt and Input2.txt and i need to have a output with selected lines starting with the values present in Input2.txt.
For example:
Input1.txt:... (5 Replies)
Discussion started by: bhas
5 Replies
7. Shell Programming and Scripting
I am trying to print 1st, 2nd, 13th and 14th fields of a file of line numbers from 29 to 10029. I dont know how to put this in one code. Currently I am removing the selected lines by
awk 'NR==29,NR==10029' File1 > File2
and then doing
awk '{print $1, $2, $13, $14}' File2 > File3
Can... (3 Replies)
Discussion started by: ananyob
3 Replies
8. Shell Programming and Scripting
Hi Experts,
The question may look very silly by seeing the title, but please have a look at it clearly.
I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which... (3 Replies)
Discussion started by: ks_reddy
3 Replies
9. Shell Programming and Scripting
Hi all, i am doing a perl script to read from a db. I am able to retrieve the rows, but i am unable to return the number of rows selected. i tried
$selectedrows = $sth->numrows; i got the error msg:
Can't locate object method "numrows" via package "DBI::st"
i changed it to $selectedrows =... (7 Replies)
Discussion started by: new2ss
7 Replies
10. Shell Programming and Scripting
I have a log file from which I want to cut out the ten lines assoictiated to my search requirment (cust_ref #).
The cust_ref number will be on te first line and the update information will be on the following ten lines (which dosen't linking data to grep on).
Using a script I would like to... (4 Replies)
Discussion started by: nhatch
4 Replies