10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.)
I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 Replies
2. Shell Programming and Scripting
Hello All,
I have three input files
cat file1
col1|col2|col3
a|1|A
b|2|B
cat file2
col1|col2|col3
c|3|C
cat file3
col1|col2|col3
d|4|D
e|5|E
i want below output
file4 col1|col2
a|1 (6 Replies)
Discussion started by: looney
6 Replies
3. Shell Programming and Scripting
I have two csv files : say a.csv, b.csv
a.csv looks like this :
property1,property2,100
property3,property4,200
In a.csv, the combination of column1 and column2 will be unique
b.csv looks like this
property1,property2, 300, t1
property1,property2, 400,t2
property3, property4,800,t1... (2 Replies)
Discussion started by: Lakshmikumari
2 Replies
4. Shell Programming and Scripting
hello everybody
I have 2 files the
file1 has 10 columns and the form:
...
110103 0802 1.16 38 20.16 22 1.21 8.77 0.00 20
120103 0832 23.40 38 22.10 21 46.35 10.17 0.00 28
120103 1413 45.00 38 24.50 21 48.85 7.89 0.00 38
130103 1112 23.40 38 22.10 21 48.85 ... (5 Replies)
Discussion started by: phaethon
5 Replies
5. Shell Programming and Scripting
Hello friends,
How can I use awk commands to obtain selective blocks from different data files. For example
file1
a b c
d e f
g h i
file2
1 2 3
4 5 6
7 8 9
output
a b 2 3
d e 5 6
g h 8 9
is it possible ? (2 Replies)
Discussion started by: rpf
2 Replies
6. Shell Programming and Scripting
Hello,
I have two files as following:
#bin chrom chromStart chromEnd name score strand observed
585 chr2 29442 29443 rs4637157 0 + C/T
585 chr2 33011 33012 rs13423995 0 + A/G
585 chr2 34502 34503 rs13386087 0 + ... (2 Replies)
Discussion started by: Homa
2 Replies
7. Shell Programming and Scripting
Hi,
I want to compare the columns of two files excluding column 2 from both the files. I tried this awk command.
awk -F":" 'NR==FNR{++a;next} !(a)' file1.txt file2.txt
.
Example: File1.txt
123:09-15-2011:abc:123456
123:09-15-2011:abc:234567
123:09-15-2011:abc:345678
... (5 Replies)
Discussion started by: shell_newbie
5 Replies
8. Shell Programming and Scripting
Hi - I have two files as follows:
File 1:
chr5 118464905 118465027 ENST00000514151 utr5 0 +
chr5 118464903 118465118 ENST00000504031 utr5 0 +
chr5 118468826 118469180 ENST00000504031 utr5 0 +
chr5 118469920 118470084 ... (14 Replies)
Discussion started by: polsum
14 Replies
9. Shell Programming and Scripting
Hello,
I'm trying to compare multiple columns between two files. I would like to use columns 1,2 from file1 and search file2 in columns 2,3 for any matches. If they match, then print columns 2,3 from file2.
file1
11:22:33:44:55:66|2010-07-25 12:30|xyz
22:22:22:22:22:22|2010-07-25... (5 Replies)
Discussion started by: pinseeker
5 Replies
10. Shell Programming and Scripting
Hi,
I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3
I also need to repeat for column 4.
Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies