merge files based on line by line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting merge files based on line by line
# 1  
Old 10-12-2009
merge files based on line by line

Hi,
lets assume the following details..

file 1 has below details
abc|1234|xyz
abc1|1234|xyz1
abc2|1234|xyz2

and file 2 has below details
pqr|124|lskd
ebwer|325|dfb
wf|234|sdb

I need out put [merged to a new file] shown below
abc|1234|xyz
pqr|124|lskd
abc1|1234|xyz1
ebwer|325|dfb
abc2|1234|xyz2
wf|234|sdb

Thanks
Hare
# 2  
Old 10-12-2009
Let's assume you tell us what you tried so far.

Last edited by Scott; 10-12-2009 at 09:11 PM..
# 3  
Old 10-12-2009
I think he means a simple merge?
Code:
paste -d'\n' file1 file2>file3

# 4  
Old 10-12-2009
Scott, i am using this way

#!/usr/bin/ksh
newfile="${1}"
newfile="${2}"
newfile="${3}"

if [ -z ${newfile} ]; then
echo "Usage: $(basename ${0}) NEWFILE FILES..."
exit 1
fi


for i in ${newfile1}; do
for j in ${newfile2}; do
for k in ${newfile3}; do
tail -n+2 ${i} >> ${newfile}
tail -n+2 ${j} >> ${newfile}
tail -n+2 ${k} >> ${newfile}
done
done
done
# 5  
Old 10-12-2009
Thanks. Not so bad. Scrutinizer has given you a better solution though, I think.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Merge files with multi-line stanzas

Hello. I try to merge few /etc/qconfig files in AIX (from few servers into one file on new server). Could you please help me what would be the best way to merge files that contain multi-line stanzas, like this: stanza1: attr1 = value1 attr2 = value2 attr3 = value3 stanza2: attr1 =... (7 Replies)
Discussion started by: kareem33
7 Replies

2. UNIX for Dummies Questions & Answers

Merge two files line by line

Hello, i want to merge two files via terminal. After three lines of file one i will append a line of file two: Example: File 1: @chr1_15953153_15953093_1_0_0_0_1:0:0_0:0:0_0/1 TGTCGTAAAATCACAACGTCCCCATCTTTCAAGCCATAAGCAGCCAATGATCTGTGGTTGTCTGTGAGAGGTCTTTCCGCATAGACGATCTACAACAAGA +... (3 Replies)
Discussion started by: Innsbrucker
3 Replies

3. Shell Programming and Scripting

Merge multiple lines to one line when line starts with and ends with

example: comment Now_TB.table column errac is for error messages 1 - first 2 - second 3 -third ; in this example I need to be able to grab the comment as first word and ; as the last word and it might span a few lines. I need it to be put all in one line without line breaks so I can... (4 Replies)
Discussion started by: wambli
4 Replies

4. Shell Programming and Scripting

Take out First Line and merge all files

Hi Gurus, I have n number of files. Data which is in the files have column headers. I need to take them out and merge into one file. Can you help please? I need to do that little urgent. Thanks (4 Replies)
Discussion started by: raopatwari
4 Replies

5. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

6. Shell Programming and Scripting

Merge two non-consecutive lines based on line number or string

This is a variation of an earlier post found here: unixcom/shell-programming-scripting/159821-merge-two-non-consecutive-lines.html User Bartus11 was kind enough to solve that example. Previously, I needed help combining two lines that are non-consecutive in a file. Now I need to do the... (7 Replies)
Discussion started by: munkee
7 Replies

7. UNIX for Dummies Questions & Answers

Merge files and add file name to the end of each line

Hello everybody, I'm trying to merge a lot of files, but I want to include the filename to the end of each line. I've tried to use cat, but I got stuck. My files are for example: file01.001 123456 aaa ddd ee 458741 eee fff ee file02.003 478596 uuu ddd ee 145269 ttt fff ee ... (4 Replies)
Discussion started by: ernesto561
4 Replies

8. Shell Programming and Scripting

Merge 2 files, line by line

Hi all, I've been looking for a way to merge 2 simple text files, line by line using the shell: For example: File1: aaaa bbbb cccc File2: 1111 2222 3333 The 2 files have the same number of lines. I'm trying to obtain: aaaa 1111 bbbb 2222 cccc 3333 (0 Replies)
Discussion started by: venezia
0 Replies

9. Shell Programming and Scripting

merge lines into single line based on symbol \t

The symbols are \t and \t\t (note: not tab) If the line starts with \t merge them into a single line upto symbol \t\t \t\t to end and start new line I able to join in a single line but not ending at \t\t and I completely confused help would be appreciated:b::D Input \ta tab XXXXXXXXXX \te... (5 Replies)
Discussion started by: repinementer
5 Replies

10. Shell Programming and Scripting

compare the column from 3 files and merge that line

I have 3 file, each of has got 80000 records. file1.txt ----------------------- ABC001;active;modify;accept; ABC002;notactive;modify;accept; ABC003;notactive;no-modify;accept; ABC004;active;modify;accept; ABC005;active;no-modify;accept; file2.txt ---------------------------... (8 Replies)
Discussion started by: ganesh_mak
8 Replies
Login or Register to Ask a Question