10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello All,
I'm working on a Shell script to join data from two files using Join command but not able to get the desired output as its throwing me an error:
I have sorted the two files on the Column 1 numerically which is used as Join clause
File 1:
1,ABC,GGG,20160401
2,XYZ,KKK,20160401... (2 Replies)
Discussion started by: venkat_reddy
2 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
I'm trying to use the join command to merge two files, but it's not finding lots of the matches.
I have three files in total:
File A:
31_77
34_46
72_61
85_10
85_23
110_33
144_45
154_25
154_90
170_5
170_44
217_63
255_19
333_20
333_23
333_32 (2 Replies)
Discussion started by: HEP
2 Replies
3. Shell Programming and Scripting
I want to join two files , with file 1 col 3 and file 2 col 1 as key.
The join command is erratic for some reason. File 2 is a master file having all the names, and file 1 has some values. I want to add the names from fil2 in file 1. If I use the original master file, some output is missing.
... (16 Replies)
Discussion started by: ritakadm
16 Replies
4. Shell Programming and Scripting
Hi All,
I have 2 files where the first column of both the files have to be compared and if they match the first six columns of the first file to be extracted in the output file.
Format of files :
File1 : ${SHTEMP}NPBR5.XTR.tmp
S00016678|129|7|MPF|20090106|E... (3 Replies)
Discussion started by: nua7
3 Replies
5. Shell Programming and Scripting
So i'm currently working on a project where I'm attempting to display information of users from the /etc/passwd file and also another information file holding addition information about users.
Problem is I've been trying to join the two files together and have all of the information about each... (2 Replies)
Discussion started by: Nostyx
2 Replies
6. Shell Programming and Scripting
sh script file1 filea fileb filec ................filez. >>output1 & output2 &output3
file1
z10 1873 1920 z_number1_E59
z10 2042 2090 z_number2_E59
Z22 2476 2560 z_number3_E59
Z22 2838 2915 z_number4_E59
z1 1873 1920 z_number1_E60
z1 ... (9 Replies)
Discussion started by: stateperl
9 Replies
7. Shell Programming and Scripting
Hi GUYS sorry for putting simple query. I have tried the methods posted previously in this site but I'm unable to join the similar values in different columns of different files.
I used sort -u file1 and join but no use.??
I'm attaching my inputfiles.Plz chek them
I have two files.
1st file... (10 Replies)
Discussion started by: repinementer
10 Replies
8. Shell Programming and Scripting
I am trying to get a script working that will perform a simple database lookup using the join command.
Here are the two files that I am trying to join:
% cat lookup1.txt
Number_1 Other_data_a
Number_5 Other_data_b
Number_8 Other_data_c
Number_10 Other_data_d
% cat... (2 Replies)
Discussion started by: JasonHamm
2 Replies
9. Shell Programming and Scripting
Hi, On the log Netscape log, I need to grep for 500 error. I am doing that but I also get 1500 in that same log.
cat access |grep "500"
Results:
"GET /css/RBR.css HTTP/1.1" 200 15000 304 - - - 399 639 523 164 0
This not what I need... Please advice. (4 Replies)
Discussion started by: samnyc
4 Replies
10. UNIX for Dummies Questions & Answers
I was trying to merge the following two example files using their first field:
join -1 1 -2 1 file1 file 2
but nothing is produced. The expected result should be:
rs1005152 7 q21.3 3
It appears that the length of the first field in file1 is causing the problem. Any suggesting on how to... (12 Replies)
Discussion started by: gamma_user
12 Replies