dear tukuyomi, i'm following exactly what you wrote and still i get only the column of $1 from file 2
---------- Post updated at 06:58 AM ---------- Previous update was at 06:48 AM ----------
ok,my bad, i was inserting file1 instead of file2 in the previous awk command...however i still get the comparison results of column $1 successfully but i'm not able to get their corresponding $2 column.
so now i get in the newly file3 after:
---------- Post updated at 07:08 AM ---------- Previous update was at 06:58 AM ----------
tukuyomi,
ok, i'll need to update you on that...the command you wrote is correct but for a weird reason this command was not fully functional on an ubuntu machine...i've tried it on cygwin in a windows environment and it worked perfectly well...sounds a bit awkward but ok,..at the very end everything now is ok
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (1 Reply)
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (4 Replies)
I have two files file1 and file 2
both are having multiple coloumns.i want to select only two columns.
i used following code to get the desired columns,with ',' as delimiter
cut -d ',' -f 1,2 file1 | sort > file1.new
cut -d ',' -f 1,2 file2 | sort > file2.new
I want to get the coloums... (1 Reply)
Hey,
I have 2 files that have a name and then a number:
File 1:
dog 21
dog 24
cat 33
cat 27
dog 76
cat 65
File 2:
dog 109
dog 248
cat 323
cat 207
cat 66 (2 Replies)
Hi,
I have two files with the same number of columns. Basically I want to print the 2 columns that match between the two files.
File1 looks like this:
dr12 12 6 abn
dr14 12 7 abn
File2 looks something like this:
dr12 12 8 abn
dr12 14 7 abn
So basically if the first... (1 Reply)
Hi,
I have two files. File1.txt has 2 columns and looks like:
458739 122345
4456 122657
34200 122600
File2.txt has many columns with column 1 the same as column2 of File1.txt, but with lot more rows:
122786 abcdefg user1@email
122778 uuhjeufh user2@email... (1 Reply)
Hello,
I have two files as 1.txt and 2.txt with number as columns.
1.txt
0 53.7988
1 -30.0859
2 20.1632
3 14.2135
4 14.6366
5 -37.6258
.
.
.
31608 -8.57333
31609 -2.58554
31610 -24.2857
2.txt (1 Reply)
Hey all, I have a file structure that looks something like this:
file1
306708278
88954535
234167885
file2
2012-03-27T12:32:56+00:00 137 Orchotorena 184616310003601409 306708278 es 40.4777947 Majadahonda -3.6416896333333333 0 false atlante83 "<a href=""http://tapbots.com/tweetbot""... (8 Replies)
Hi all,
I have two files as below. I need to compare field 2 of file 1 against field 1 of file 2 and field 5 of file 1 against filed 2 of file 2. If both matches , then create a result file 1 with first file data and if not matches , then create file with first fie data. Please help me in... (12 Replies)
Discussion started by: sivarajb
12 Replies
LEARN ABOUT MINIX
paste
PASTE(1) General Commands Manual PASTE(1)NAME
paste - paste multiple files together
SYNOPSIS
paste [-s] [-d list] file...
OPTIONS -d Set delimiter used to separate columns to list.
-s Print files sequentially, file k on line k.
EXAMPLES
paste file1 file2 # Print file1 in col 1, file2 in col 2
paste -s f1 f2 # Print f1 on line 1 and f2 on line 2
paste -d : file1 file2
# Print the lines separated by a colon
DESCRIPTION
Paste concatenates corresponding lines of the given input files and writes them to standard output. The lines of the different files are
separated by the delimiters given with the option -s. If no list is given, a tab is substituted for every linefeed, except the last one.
If end-of-file is hit on an input file, subsequent lines are empty. Suppose a set of k files each has one word per line. Then the paste
output will have k columns, with the contents of file j in column j. If the -s flag is given, then the first file is on line 1, the second
file on line 2, etc. In effect, -s turns the output sideways.
If a list of delimiters is given, they are used in turn. The C escape sequences
, , \, and are used for linefeed, tab, backslash,
and the null string, respectively.
PASTE(1)