10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to match $1-$7 between the two files and if a match is found then the contents of $8 in file2 and copied over. The awk I tried is below. There is also a header row in file2 that has the Chr Start End Ref Alt that does not need to be searched. Thank you :).
awk... (3 Replies)
Discussion started by: cmccabe
2. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
3. UNIX for Dummies Questions & Answers
I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!
1 1 ABC DEF
2 2 IJK LMN
1 2 ZYX OPW
1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
4. UNIX for Dummies Questions & Answers
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
5. Shell Programming and Scripting
I have a data file input.csv like below. (Only five column shown here for example.)
From this I want the below output
where the second column... (4 Replies)
Discussion started by: ks_reddy
6. UNIX for Dummies Questions & Answers
Please help me with this one. I have an file with the following contents:
I would like to make to transform it to look like this as my output file:
d,e,f (4 Replies)
Discussion started by: kokoro
7. Shell Programming and Scripting
suppose I have the following file and certain rows have missing columns,
how do i skip these rows and create an output file which has all the columns in it
E/N Ko_exp %err Ko_calc %err diff diff- diff+ 0.95
======== ======= ==== ======= ==== ===== ===== =====... (12 Replies)
Discussion started by: ramky79
8. UNIX for Dummies Questions & Answers
I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with... (8 Replies)
Discussion started by: auburn
9. Shell Programming and Scripting
i have a file in below format where the barcode's are uniq per site but could be repeated for different site. so i want to convert the site column to rows based on the barcode's as below output.
your help is appreciated!!!
SITE BARCODE QTY SP CP
10001 6281103890017 10 50 48... (5 Replies)
Discussion started by: malcomex999
10. Shell Programming and Scripting
I could not find this on the search..
I want to know how to trim a row
so lets say I have a file that looks like this:
and I want to trim column 2 (lets say 4 off the front and end)
Also, how would I bin column 2
Lets so I want to add and average... (1 Reply)
Discussion started by: phil_heath