Sponsored Content
Top Forums Shell Programming and Scripting Paste 2 single column files to a single file Post 302949295 by Don Cragun on Thursday 9th of July 2015 01:10:43 AM
Old 07-09-2015
I will assume for now the that updated sample files you showed us in post #3 in this thread were some kind of copy and paste error??????

With the renamed sample input files in your updated post #1 in this thread, with the command:
Code:
paste output2.csv output3.csv

I would expect to get the output:
Code:
http://www1.abc.com/cms/slp/2/Flowerbomb	flowerbomb
http://www1.abc.com/cms/slp/2/Everlon-Jewelry	everlon-jewelry
http://www1.abc.com/cms/slp/2/Sofft	sofft
http://www1.abc.com/cms/slp/2/Steve-Madden	steve-madden
http://www1.abc.com/cms/slp/2/Dolce-Gabbana-Watch	dolce-gabbana-watch

But, if your input files had Windows style line terminators (<carriage-return><line-feed> character pairs) instead of UNIX style line terminators (single <line-feed> (AKA <newline>) characters), then you would get output similar to what you showed us:
Code:
http://wflowerbombm/cms/slp/2/Flowerbomb
http://weverlon-jewelry/slp/2/Everlon-Jewelry
http://wsofftbc.com/cms/slp/2/Sofft
http://wsteve-maddencms/slp/2/Steve-Madden
http://wdolce-gabbana-watch/2/Dolce-Gabbana-Watch

So, get rid of the <carriage-return> characters in your input files and everything should be fine. But, of course, since you still haven't shown us what output you are trying to produce, we are all just guessing.

Assuming my guess at your desired output is correct and assuming that you don't have any hard links to the files output[23].csv, the following commands should get rid of the <carriage-return>s for you:
Code:
tr -d '\r' < output2.csv > $$.csv && mv $$.csv output2.csv
tr -d '\r' < output3.csv > $$.csv && mv $$.csv output3.csv

and then your paste commands should work.
 

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
Alien::Package::Slp(3pm)				User Contributed Perl Documentation				  Alien::Package::Slp(3pm)

NAME
Alien::Package::Slp - an object that represents a slp package DESCRIPTION
This is an object class that represents a slp package. It is derived from Alien::Package. CLASS DATA
The following data is global to the class, and is used to describe the slp package format, which this class processes directly. footer_size Complete sizeof(slpformat) from slp.h in the stampede package manager source. footer_packstring This is the pack format string for the footer. (A=space terminated character, I=unsigned integer.) footer_version What package format are we up to now? (Lowest one this is still compatable with.) archtrans This is a translation table between architectures and the number that represents them in a slp package. fieldlist This is a list of all the fields in the order they appear in the footer. FIELDS
compresstype Holds the compression type used in the slp file. slpkgversion Holds the slp package format version of the slp file. METHODS
checkfile Detect slp files by their extention. install Install a slp. Pass in the filename of the slp to install. getfooter Pulls the footer out of the slp file and returns it. scan Implement the scan method to read a slp file. unpack Unpack a slp file. They can be compressed in various ways, depending on what is in the compresstype field. build Build a slp. conffiles Set/get conffiles. When the conffiles are set, the format used by slp (a colon-delimited list) is turned into the real list that is used internally. The list is changed back into slp's internal format when it is retreived. copyright Set/get copyright. When the copyright is set, the number used by slp is changed into a textual description. This is changed back into a number when the value is retreived. arch Set/get arch. When the arch is set, the number used by slp is changed into a textual description. This is changed back into a number when the value is retreived. release Set/get release version. When the release version is retreived, it is converted to an unsigned integer, as is required by the slp package format. AUTHOR
Joey Hess <joey@kitenet.net> perl v5.12.3 2011-06-11 Alien::Package::Slp(3pm)
All times are GMT -4. The time now is 01:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy