|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to Merge / combine / join / paste 2 text files side-by-side
Post 302311052 by rubin on Monday 27th of April 2009 07:25:25 PM
04-27-2009
Code:
NR==FNR { a[c=FNR]=$0; next }
{ printf "%-8s\t%s\n", a[FNR], $0 }
This part is similar to the code you posted, there are many threads here that explain it, you can search the forums using the keyword NR==FNR.
Regarding printf, check this: The GNU Awk User's GuideCode:
END { for(i=FNR+1;i<=c;i++) print a[i] }'
This last section will print the remaining records of the file that has more records, already stored at the NR==FNR part, and it'll start after
all records of the smaller file are exhausted. This part will get executed only if say file2 has more records than file1, otherwise it won't
run at all.
.|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls
Eno Ename
101 hello
102 hero
103 india
bbc.xls
Eno Ename
201 delhi
202 Hyd
203... (0 Replies)
Discussion started by: jagadish99
0 Replies
2. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls bbc.xls
Eno Ename Eno Ename
101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies
3. Shell Programming and Scripting
Inquiring minds want to know.... I need to take two files that I have latitude and longitude values and then combine them into one file with the values side by side separated by a space.
the first file is temp113-lat.txt and the second is temp113-lon.txt. They each have values listed in the... (15 Replies)
Discussion started by: ahinkebein
15 Replies
4. Shell Programming and Scripting
I know this is a stupid question for you guys!
half day googling and i got nothing :(
i have 3 variables/files, say:
$X1 or file1:
# there is one whitespace space after each line
| 21
| 9
| 28
| 100
| 51
$X2 or file2:
# there is one whitespace space... (7 Replies)
Discussion started by: amaulana
7 Replies
5. Shell Programming and Scripting
Hi Everyone,
I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side.
File1:
a b c d
2 3 4 5
f g h i
..........
File2:
I II III IV
w x y z
..............
and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies
6. Shell Programming and Scripting
Input file_1:
P78811
P40108
O17861
Q6NTW1
P40986
Q6PBK1
P38264
Q6PBK1
Q9CZ49
Q1GZI0
Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies
7. Shell Programming and Scripting
Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns.
For example:
file1
ABC
DEF
GHI
file2
DEF
DER
file3
ABC
DER
The output should come out like this
file1 file2 file3
ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies
8. Shell Programming and Scripting
I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same.
For example file1 contains
cat
dog
File 2 contains
rat
mat
Output file should be
cat rat
dog mat
Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies
9. UNIX for Dummies Questions & Answers
Hi,
Thank you for your help in advance :D.
I have thousands of files like...
file01
file02
file03
.
.
.
file6324
I would like to paste every other file side by side so it looks like
file01 file02
file03 file04
...e.t.c
file6323 file6324 (3 Replies)
Discussion started by: shaz1990
3 Replies
10. Shell Programming and Scripting
Hi everyone,
I need to merge two files side by side
The files look something like this:
HOSTNAME
fishtornado-K52F 127.0.1.1
UPTIME
20:17:01 up 2:19, 3 users,
load average: 0.00, 0.04, 0.05
DISK USAGE
(Size/Used/Avail/Use%)
29G 6.5G 21G 25%
RUN QUEUE
PID COMMAND USER ... (4 Replies)
Discussion started by: FishTornado
4 Replies
LEARN ABOUT DEBIAN
cfourcc
cfourcc(1) User Commands cfourcc(1) NAME
cfourcc - tool for changing FourCC in Microsoft RIFF AVI files SYNOPSIS
cfourcc [-i] <file.avi> cfourcc -u <CODE> <file.avi> OPTIONS
-h Show summary of options. -d CODE Sets FOURCC codec decription string. -f Force changing FOURCC on unsupported file -i Display FOURCC information (default). -u CODE Set FOURCC codec. None. DESCRIPTION
Program identifies the codec used in AVI files (*.avi) and allows the user to change the FourCC description code (like fourcc-changer in Windows). Useful for people working with Microsoft AVI file. A Linux clone of AviC fourcc changer tool. EXAMPLES
Note that you only need to change the -u codec field most of the time and not touch the -d description: cfourcc -u DIVX -d DIVX file.avi ENVIRONMENT
None. FILES
None. SEE ALSO
ffmpeg(1) mplayer(1) AUTHORS
cfourcc was written by Mohammad Hafiz bin Ismail aka "mypapit" <info@mypapit.net>. This manual page was written by Jarno Elonen <elonen@debian.org>, for the Debian project (but may be used by others). Updated by Jari Aalto <jari.aalto@cante.net>. Released under license GNU GPL v2 or (at your option) any later version. For more information about license, visit <http://www.gnu.org/copyleft/gpl.html>. cfourcc 2012-04-02 cfourcc(1)