Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Paste 2 single column files to a single file
Top Forums Shell Programming and Scripting Paste 2 single column files to a single file Post 302949290 by ajayakunuri on Thursday 9th of July 2015 12:03:31 AM
Old 07-09-2015
Sorry about the names:

Code:
output2.csv

Code:










Code:



http://www1.abc.com/cms/slp/2/Flowerbomb http://www1.abc.com/cms/slp/2/Everlon-Jewelry http://www1.abc.com/cms/slp/2/Sofft http://www1.abc.com/cms/slp/2/Steve-Madden http://www1.abc.com/cms/slp/2/Dolce-Gabbana-Watch














Code:



output3.csv










Code:



flowerbomb everlon-jewelry sofft steve-madden dolce-gabbana-watch











Command that I am using: 




Code:



paste output2.csv output3.csv











Output that I received:




Code:













Code:



http://wflowerbombcom/cms/slp/2/Flowerbomb http://weverlon-jewelryms/slp/2/Everlon-Jewelry http://wsofftacys.com/cms/slp/2/Sofft http://wsteve-maddenm/cms/slp/2/Steve-Madden http://wdolce-gabbana-watchlp/2/Dolce-Gabbana-Watch











www1.abc.com is getting replaced by the output3.csv file. 

I tried using paste -d, as well and it is not working. 



Please let me know for any clarification. 



Thanks

Ajay



---------- Post updated 07-09-15 at 12:03 AM ---------- Previous update was 07-08-15 at 11:54 PM ----------



Hi,

Corrected in the initial post. Sorry for the confusion. 



Thanks

Ajay







        

        

       



            
            
            
            


            

            
            




            
                
            

            

        



        


        


 


        

        
        

        


 

            
        




















	


		


		 
		
			












	
	









    







10 More Discussions You Might Find Interesting











1. Shell Programming and Scripting






 Need help recurrently cutting single column file




Hi there !  
I have file with single column. I want to cut that column at fixed number of rows each time and paste in another file,  in a way that in new file, the each cutting appear as separate columns. 
 
I mean cutting file with one column of 10000 rows, with 100 rows each time, and in new file... (3 Replies)





Discussion started by: jacks



3 Replies








2. UNIX for Dummies Questions & Answers






 Compare 2 files for a single column and output differences




Hi, 
 
I have a column in 2 different files which i want to compare, and output the results to a different file. The columns are in different positions in those 2 files. 
File 1 the column is in position 10-15 
File 2 the column is in position 15-20 
 
Please advise 
 
Thanks (1 Reply)





Discussion started by: samit_9999



1 Replies








3. Shell Programming and Scripting






 paste each 10 lines of single column to several column




Hi, 
 
I need to paste each 10 lines of single column to several columns. 
Please, can anyone tell me how to write in awk? 
 
Input File: 
 
22 
34 
36 
12 
17 
19 
15 
11 
89 
99 
56 
38 
29 (4 Replies)





Discussion started by: nica



4 Replies








4. Shell Programming and Scripting






 Split single file into multiple files based on the number in the column




Dear All, 
 
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): 
 
ATOM      1  N   GLY A   1      -3.198  27.537  -5.958  1.00  0.00           N   
ATOM      2  CA  GLY A   1      -2.199  28.399  -6.617  1.00  0.00  ... (3 Replies)





Discussion started by: tomasl



3 Replies








5. UNIX for Advanced & Expert Users






 need to get single column form csv file




hi 2 all  
  
i need to get single column from one csv file  
  
anyone help me ! 
 
>cat file.csv  
name,age 
x,1 
y,2 
z,3 
 
 
Use code tags please, ty. 
  
in this "file.csv" file i need only name column  
  
can u help me !:b::b: (7 Replies)





Discussion started by: ponmuthu



7 Replies








6. Shell Programming and Scripting






 Multiple lines in a single column to be merged as a single line for a record




Hi, 
I have a requirement with, 
  
No~Dt~Notes 
1~2011/08/1~"aaa 
bbb 
ccc 
ddd 
eee 
fff 
ggg 
hhh" 
  
Single column alone got splitted into multiple lines.  
  
I require the output as  
  
No~Dt~Notes 
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" 
mean to say those new lines to be... (1 Reply)





Discussion started by: Bhuvaneswari



1 Replies








7. UNIX for Dummies Questions & Answers






 Sorting a txt file that is a single column




How do you sort a text file that is made up of a single column? (sorting done in alphabetical order) 
 
Example input: 
MAP1S 
ISYNA1 
STAT6 
 
Example output:  
ISYNA1 
MAP1S 
STAT6 (1 Reply)





Discussion started by: evelibertine



1 Replies








8. UNIX for Dummies Questions & Answers






 How to separate a single column file into files of the same size (i.e. number of rows)?




I have a text file with 1,000,000 rows (It is a single column text file of numbers). I would like to separate the text file into 100 files of equal size (i.e. number of rows). The first file will contain the first 10,000 rows, the second row will contain the second 10,000 rows (rows 10,001-20,000)... (2 Replies)





Discussion started by: evelibertine



2 Replies








9. UNIX for Dummies Questions & Answers






 List several files into one single column




frtgyh (2 Replies)





Discussion started by: lucasvs



2 Replies








10. UNIX for Beginners Questions & Answers






 How to copy a column of multiple files and paste into new excel file (next to column)?




I have data of an excel files as given below, 
file1 
org1_1	1	1	2.5	100 
org1_2	1	2	5.5	98	 
org1_3	1	3	7.2	88 
 
file2 
org2_1	1	1	2.5	100 
org2_2	1	2	5.5	56	 
org2_3	1	3	7.2	70 
I have multiple excel files as above shown.  
 
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)





Discussion started by: dineshkumarsrk



26 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)





















All times are GMT -4. The time now is 05:17 AM.









	






















	
	

Unix & Linux Forums Content Copyright  1993-2022. All Rights Reserved. 

        



Privacy Policy