Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

awk command to paste 1st columns of 2 files.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers awk command to paste 1st columns of 2 files.
# 1  
Old 01-08-2020
awk command to paste 1st columns of 2 files.
I have 2 files contains more than 5000 lines, I want to paste the 1st column of both file in an output file using awk.
Please suggest to me I had tried paste command but it merges my both column.

--- Post updated at 10:26 PM ---

file1.txt
Code:
2020-01-07 235400
2020-01-07 235400
2020-01-07 235401
2020-01-07 235401
2020-01-07 235401
2020-01-07 235401
2020-01-07 235401
2020-01-07 235404
2020-01-07 235404
2020-01-07 235752




file2.txt
Code:
ossuser
ossuser
ossuser
ossuser
ossuser
ossuser
ossuser
ossuser
ossuser
ossuser


required output

Code:
2020-01-05 020012      ossuser
2020-01-05 020014      ossuser
2020-01-05 020014      ossuser
2020-01-05 020014      ossuser
2020-01-05 020109      ossuser
2020-01-05 020230      ossuser
2020-01-05 020240      ossuser
2020-01-05 020240      ossuser
2020-01-05 020241      ossuser
2020-01-05 020241      ossuser
2020-01-05 020241      ossuser
2020-01-05 020242      ossuser
2020-01-05 020242      ossuser
2020-01-05 020242      ossuser
2020-01-05 020242      ossuser



I am getting merged output like this by using paste
Code:
paste file1 file2
2020-01-ossuser00
2020-01-ossuser00
2020-01-ossuser01
2020-01-ossuser01
2020-01-ossuser01
2020-01-ossuser01
2020-01-ossuser01
2020-01-ossuser04
2020-01-ossuser04
2020-01-ossuser52

Please suggest Thanks in Advance

Moderator's Comments:
Mod Comment Please do wrap your samples/codes in CODE TAGS as per forum rules.
Last edited by RavinderSingh13; 01-08-2020 at 10:13 PM..
# 2  
Old 01-08-2020
Can't reproduce your problem:
Code:
paste file[12]
2020-01-07 235400    ossuser
2020-01-07 235400    ossuser
2020-01-07 235401    ossuser
2020-01-07 235401    ossuser
2020-01-07 235401    ossuser
2020-01-07 235401    ossuser
2020-01-07 235401    ossuser
2020-01-07 235404    ossuser
2020-01-07 235404    ossuser
2020-01-07 235752    ossuser

but neither can produce your required output as no e.g. 2020-01-05 020012 is in your input data.
With strange problems like this, I usually presume non-printing control characters in file, like the DOS line terminator <CR> (\r = ^M = 0x0D).
# 3  
Old 01-08-2020
Hi,
Actually my file contains approx 3000 lines that's why I am getting this type of output.
Can you please suggest me any other command to get the same output using awk.
# 4  
Old 01-08-2020
Quote:
Originally Posted by Sagar Singh
Hi,
Actually my file contains approx 3000 lines that's why I am getting this type of output.
...
Definitely not. paste handles 3000 lines (and more!) nicely. The presumed errors in the input files will make awk fail as well. Get those errors corrected, and retry.
# 5  
Old 01-09-2020
What do these give you?
Code:
grep -n '' file1 | head 
grep -n '' file2 | head

I agree that this is most likely peculiar characters in the data. To see if we can spot something, can you:
Code:
head file1 | od -tx
head file2 | od -tx

Please paste the output exactly and wrap it in CODE tags.




Thanks, in advance,
Robin
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to use "awk" to print columns from different files in separate columns?

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

Paste columns based on common column: multiple files

Hi all, I've multiple files. In this case 5. Space separated columns. Each file has 12 columns. Each file has 300-400K lines. I want to get the output such that if a value in column 2 is present in all the files then get all the columns of that value and print it side by side. Desired output... (15 Replies)
Discussion started by: genome
15 Replies

3. UNIX for Beginners Questions & Answers

Character screening and paste into newfile in columns instead of rows

QL10169_SAUJANA%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KCRN11,MeContext=QL10169_SAUJANA_5 %External_Link_Failure %X2_link_problem_to_one_or_several_neighbouring_eNodeBs. QL10187_MATANG_JAYA_2%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KUCHING,MeContext=QL10187_MATANG_JAYA_2_3... (2 Replies)
Discussion started by: Ankit Vyas
2 Replies

4. Shell Programming and Scripting

Character screening and paste into new file in columns instead of rows

QL10169_SAUJANA%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KCRN11,MeContext=QL10169_SAUJANA_5 %External_Link_Failure %X2_link_problem_to_one_or_several_neighbouring_eNodeBs. QL10187_MATANG_JAYA_2%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KUCHING,MeContext=QL10187_MATANG_JAY A_2_3... (2 Replies)
Discussion started by: Ankit Vyas
2 Replies

5. Shell Programming and Scripting

awk command to replace columns in 2 files

Hi All, I already have a code which replaces column 14 of NPBR.XTR.tmp with column 8 of NPBR3G.XTR.final awk -F'\|' 'FNR==NR{a= $2"^"$8;next;}a{split(a,b,"^");$8=b;$14=b;}1' OFS="|" ${SHTEMP}NPBR3G.XTR.final ${SHTEMP}NPBR.XTR.tmp > ${SHTEMP}NPBR.XTR.final I also need to replace column 15... (2 Replies)
Discussion started by: nua7
2 Replies

6. Shell Programming and Scripting

Paste second columns from files to its corresponding file

Hi All, I have two sets of files. One set with extension .txt This set has file names with numbers like these. 1.txt, 2.txt, 3.txt until extactly 100.txt. The .txt files look like these: 0.38701788 93750 0.38622013 94456 0.38350296 94440 0.38282126 94057 0.38282126 94439 0.35847232... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

7. Shell Programming and Scripting

Copy and Paste Columns in a Tab-Limited Text file

I have this text file with a very large number of columns (10,000+) and I want to move the first column to the position of the six column so that the text file looks like this: Before cutting and pasting ID Family Mother Father Trait Phenotype aaa bbb ... (5 Replies)
Discussion started by: evelibertine
5 Replies

8. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

input1 a_a a/a 10 100 a1 a_a 20 200 b1 b_b 30 300 input2 a_a a/a xxx yyy a1 a1 lll ppp b1 b_b kkk ooo output a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 Replies

9. Shell Programming and Scripting

appending several columns with awk and paste

Hello, I am trying to solve for a couple of hours now the following problem: I have n files and would like to add the third column of each file to a new file: temp1.txt 1 2 3 1 2 3 1 2 3 temp2.txt 1 2 4 1 2 4 1 2 4 1 2 4 temp3.txt (2 Replies)
Discussion started by: creamcheese
2 Replies

10. UNIX for Dummies Questions & Answers

cut and paste columns using awk

Hi, Let's say that I have a file called table, I know that if I need to see a the second column for exampls I use: awk ' {print $2}' table.txt Is there anyway to use awk to actually cut a column and put it somewhere else in the table?:confused: (8 Replies)
Discussion started by: cosmologist
8 Replies
Login or Register to Ask a Question