Hi Friends,
Please help.
I have 2 pipe delimited files; each one has different number of rows in it. I want to use "paste" to concatenate these files.
However, while doing it, due to difference in number of rows in each files resulting file is in haphazard manner.
E.g.
file 1
File_2
cat file_3
However I want it to look like following in excel after text-to-column.
_Anu
Last edited by Franklin52; 07-11-2012 at 05:03 PM..
Reason: Please use code tags for data and code samples, thank you
I have a text file that has over 300 lines that I need to paste identical data to. What is the easiest way to do this? For example if I have a file that has lines of text xxxxxxxx and I would like to change each line to look like this "display text(xxxxxxxx)". What would be the easiest way to do... (3 Replies)
Hi, I would like to paste multiple files together into one large file.
I have 23 of them and I would like to link them on a common variable without writing all the file names out (like in a simple join). Each has about 28,000 columns, but only 17 rows.
So the final product would be a single file... (2 Replies)
hey,
I have more a structural problem. I have two input files:
1.inp:
1 2 3 a b c
2 3 4 d f g
and the 2.inp
6 6 6
7 7 7
8 8 8
The goal is to get as much output files (with a name 1_2_3.dat) as lines in 1.inp are like this:
6 6 6 a
7 7 7 b
8 8 8 c (5 Replies)
i have two files with contents
file a
1234,abcf
2345,drft
4444,befr
file b
tom,3
sam,5
dog,7
i want to print first column of file b and join to file a and get output as below
tom,1234,abcf
sam,2345,drft
dog,4444,befr (2 Replies)
Hi All,
I have .csv file in which I am trying to manipulate a column date, I started with awk but i am not sure how to do the below logic in .
the file has a 23 columns and in the first row if the value is Trend and in the second column the value is Analysis then the program has to... (3 Replies)
I have two text files: One is a single column of numbers and the other is a space delimited text file with multiple columns. I want to paste the single column of numbers into the second column of the latter text file. How do I go about doing that? Thanks! (1 Reply)
I have a file laid out in columns with the first two lines line being:
219 432 4567
219 432 4587
I need to create a single line command to cut the characters in the 5th column and paste them back to the first column in the same file. (Hint:Two good solutions exist, one in which you use a... (9 Replies)
quick question.. say i have few files in D or E drive.. i want to paste them in Filesystem that is /home/vivek folder... but when i try to do that it shows some error saying "There is not enough space on the destination. Try to remove files to make space."
but i think its due to authorization... (3 Replies)
Hello Gurus,
This is my first ever post here. I tried looking for similar material but came up empty handed. Apologies if this is too verbose or if I'm not using the correct formatting.
I have files containing a fixed number of elements per line; separator is a single space. Each line has the... (4 Replies)
Hello everyone.
When I copy some configuration settings string from MS_Word to putty from my personal pc to a remote machine, it appears that I copy some hidden symbols, which at first, cannot be seen and appear as hidden. Some java programs did not start, and after investigation I found that:
... (3 Replies)
Discussion started by: dampio
3 Replies
LEARN ABOUT NETBSD
paste
PASTE(1) BSD General Commands Manual PASTE(1)NAME
paste -- merge corresponding or subsequent lines of files
SYNOPSIS
paste [-s] [-d list] file ...
DESCRIPTION
The paste utility concatenates the corresponding lines of the given input files, replacing all but the last file's newline characters with a
single tab character, and writes the resulting lines to standard output. If end-of-file is reached on an input file while other input files
still contain data, the file is treated as if it were an endless source of empty lines.
The options are as follows:
-d list Use one or more of the provided characters to replace the newline characters instead of the default tab. The characters in list
are used circularly, i.e., when list is exhausted the first character from list is reused. This continues until a line from the
last input file (in default operation) or the last line in each file (using the -s option) is displayed, at which time paste
begins selecting characters from the beginning of list again.
The following special characters can also be used in list:
newline character
tab character
\ backslash character
Empty string (not a null character).
Any other character preceded by a backslash is equivalent to the character itself.
-s Concatenate all of the lines of each separate input file in command line order. The newline character of every line except the
last line in each input file is replaced with the tab character, unless otherwise specified by the -d option.
If '-' is specified for one or more of the input files, the standard input is used; standard input is read one line at a time, circularly,
for each instance of '-'.
The paste utility exits 0 on success, and >0 if an error occurs.
SEE ALSO cut(1)STANDARDS
The paste utility is expected to be IEEE Std 1003.2 (``POSIX.2'') compatible.
BSD June 6, 1993 BSD