Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

how to combine text files

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to combine text files
# 1  
Old 03-30-2011
how to combine text files
how to combine text files in new file and be separated by commas :
example:
f1.txt
Code:
1
2
3

f2.txt
Code:
x
y
z

f3.txt
Code:
m
n
o

i need output to be
fnew.txt
Code:
1,x,m
2,y,n
3,z,o

and if you know how to reverse the above process please help
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!
Last edited by vgersh99; 03-30-2011 at 04:50 PM.. Reason: code tags, please!
# 2  
Old 03-30-2011
Code:
paste  -d ',' f1.txt f2.txt f3.txt > fnew.txt

This User Gave Thanks to vgersh99 For This Post:
takyeldin
# 3  
Old 03-30-2011
Code:
$ paste -d "," file1 file2 file3
1,x,m
2,y,n
3,z,o
$

This User Gave Thanks to Corona688 For This Post:
takyeldin
# 4  
Old 03-30-2011
thanks, but when using cat fnew.txt
output
Code:
,m
,n
3,z,o

# 5  
Old 03-30-2011
Please show what you actually typed to create that file.

Blank lines in the input files won't be ignored by paste.
# 6  
Old 03-30-2011
^M's produce that output:
Code:
$ cat -v f[123].txt
1^M
2^M
3
x^M
y^M
z
m^M
n^M
o

$ paste  -d ',' f1.txt f2.txt f3.txt
,m
,n
3,z,o

# 7  
Old 03-30-2011
sorry guys i'm using unix emulator so i created those three files by windows and used them in the print -d command

but after i created those files using cat command the output became right

i don't know what is the reason that causes it ?!!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Automate splitting of files , scp files as each split completes and combine files on target server

i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies

2. Shell Programming and Scripting

Combine Two Text Files (PERMUTE)

Hello everybody, I would like to know how can I obtain this: There are two text files.....ffirst.txt and fsecond.txt ffirst.txt contains 5 lines (example): A B C D E fsecond.txt contains 10 lines (example): 1 2 3 4 5 6 (4 Replies)
Discussion started by: gandrinno1
4 Replies

3. Shell Programming and Scripting

Combine two text files

Hi I use Ubuntu 14.04 LTS and bash shell. I need help to write a script to combine two text files. The first file is FIRST.txt <Text Text_ID="10155645315851111_10155645333076543" From="460350337461111" Created="2011-03-16T17:05:37+0000" use_count="123">This is the first text</Text> <Text... (15 Replies)
Discussion started by: my_Perl
15 Replies

4. Shell Programming and Scripting

Combine the lines from separate text files

Hi All, I have three separate text files which has only one line and i want to combine these lines in one text file which will have three lines. cat file1.txt abc cat file2.txt 1265 6589 1367 cat file3.txt 0.98 0.36 0.5 So, I want to see these three lines in the... (9 Replies)
Discussion started by: senayasma
9 Replies

5. Shell Programming and Scripting

conditionally combine text from two files into one

Hi! I'm trying to take multiple text files (6), which have text on some lines but not others, and combine them. I'd also like to make the values in one column of some of the files (files 4-6) negative. I'm trying to write a short script (see below) as I have to do this with a large number of... (2 Replies)
Discussion started by: felix.echidna
2 Replies

6. Shell Programming and Scripting

Combine Multiple text or csv files column-wise

Hi All I am trying to combine columns from multiple text files into a single file using paste command but the record length being unequal in the different files the data is running over to the closest empty cell on the left. Please see below. What can i do to resolve this ? File 1 File... (15 Replies)
Discussion started by: venky_ibm
15 Replies

7. Shell Programming and Scripting

how to combine 2 lines in same files based on any text

hi, I want to combine two lines in same file. If the line ends with '&' it should belongs to previous line only Here i am writing example. Ex1: line 1 : return abcdefgh& line 2 : ijklmnopqr& line 3 : stuvw& line 4 : xyz output should be line 1: return abcdefghijklmnopqrstuvwxyz ... (11 Replies)
Discussion started by: spc432
11 Replies

8. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car... (3 Replies)
Discussion started by: cajunfries
3 Replies

9. UNIX for Dummies Questions & Answers

combine text files into one file

I need to write a shell script which combines/joins 3 text files into one file. Do i put the txt files in the same folder as my script? Here is what i have: #!/bin/bash file1=$1 file2=$2 file3=$3 out="output.txt" count=0 if then echo "$(basename $0) file1 file2 file3" ... (3 Replies)
Discussion started by: zzthejimzz
3 Replies

10. Shell Programming and Scripting

How to combine text data into one line?

The following input needs to be manipulated as follows: INPUT from file or results of command: ============start: Medium identifier : a45c0213:47eb5485:0aec:0321 Medium label : SQL Disk_11516 Location : Protected : None ... (2 Replies)
Discussion started by: rcky_mntere
2 Replies
Login or Register to Ask a Question