Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..
output3.csv: output2.csv:
when I do:
Here is the output received:
www1.abc.com is getting replaced by the output3.csv file.
I tried using paste -d, as well and it is not working.
Can you please advice?
Thanks
Ajay
Moderator's Comments:
Please use CODE tags for all sample input, output, and code segments.
Last edited by ajayakunuri; 07-09-2015 at 01:01 AM..
Reason: Add CODE and ICODE tags.
I don't get it. You show us the contents of File1.csv and File2.csv and then you show us a command that pastes two files we haven't seen that produces output that looks suspiciously like File2.csv.
We might be able to help if you would show us the contents of output2.csv and output3.csv and show us the output you are hoping to get (all inside CODE tags).
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:
I would expect to get the output:
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:
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:
and then your paste commands should work.
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)
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)
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)
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)
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)
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)
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)
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)
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)