Merge 3 files in 1 file in an ordered way


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Merge 3 files in 1 file in an ordered way
# 15  
Old 03-27-2010
MySQL

Code:
 
xlength=`cat x-values.dat|wc -l`
plength=`cat p-values.dat|wc -l`
ylength=`cat y-values.dat|wc -l`

count=0
if [ $plength != $count ]
 then
  while read -r a
  do
   printf -v line '%*s' "$ylength"
   echo ${line// /$a} | grep -o "$a" >> x-values.datnew
  done < x-values.dat
 let count=$count+1
 else
 break
fi

count=0
while [ $xlength != $count ]
do
 cat y-values.dat>> y-values.datnew
 let count=$count+1
 continue
done

paste -d " " x-values.datnew y-values.datnew p-values.dat > new-values.dat
rm -f x-values.datnew y-values.datnew
cat new-values.dat

# end of script

# 16  
Old 03-27-2010
Quote:
Originally Posted by lego
Yes, the script by Franklin works with any number of lines in x (lets say, nx) and y (lets say ny). The number of lines in p (np) has to be np=nx*ny. But this is how I stated the problem..

so it's ok.
I'm just a bit curious: I just want to know if my bash solution worked by you. (because it works by me with your sample and is independent of the numbers x and y rows.)
# 17  
Old 03-27-2010
Yes frans, your script worked for me for any number of rows in x-values and y-values (provided np=nx*ny).

Thank you so much!
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge different files into the original file

Hello Below is my requirement I have 3 files A1.txt , A2.txt and A3.txt . A2 is dynamically generating file I want the merge of A1,A2 and A3 in A2.txt Could you please help? (3 Replies)
Discussion started by: Pratik4891
3 Replies

2. UNIX for Dummies Questions & Answers

How to merge two files into third file?

Hi All, i have a requirement as below. There are two files. In 1st file a.txt i have four lines as below Ramesh Suresh Pradeep Franklin In 2nd file b.txt i have 5 lines as below Francis Elizabeth David John Ravi The output file suppose c.txt should contain 1st line of... (5 Replies)
Discussion started by: sureshk_85
5 Replies

3. Shell Programming and Scripting

Merge two files into one file

Hi, I need help with merging two files. My requirement is as below: File 1: MachineA MachineB File 2: Process1 Process2 Desired File: MachineA Process1 MachineB Process2 If file 2 contains only one entry Process1, then second line in the desired output should be: MachineA Process1... (1 Reply)
Discussion started by: chiru_h
1 Replies

4. UNIX for Dummies Questions & Answers

merge files along with file names (awk)?

Dear programmers, I have a question about conditionally merging multiple files and having their file names in the first column. Input files: file.1.extension file.2.extension file.3.extension file.4.extension ... file.1000.extension where each file looks like this (with multiple lines):... (5 Replies)
Discussion started by: wei.deng
5 Replies

5. Programming

Merge files from /etc to one file using C

Hi guys, I have a question which might be easy to answer but I don't how to do it. The thing is I need to make a program in C which creates a file with all the content from the files in \etc. I'm not new to C language but to UNIX. I've read somewhere I need to use functions like f_read... (2 Replies)
Discussion started by: sussil
2 Replies

6. Shell Programming and Scripting

merge two files into one file use awk

Hi, guys. I have one question: I have two files: passwd and shadow (the number of records in these files are not equal)the contents of them are below: passwd: ************** ftp:x:24:24: sshd:x:71:65: uucp:x:10:14: brownj:x:5005:1000: sherrys: x :5006:1000: ... ************* ... (2 Replies)
Discussion started by: daikeyang
2 Replies

7. Shell Programming and Scripting

Merge two files whose names are given in other file

Hi, I have a pointer file ptr.txt. There may be any number of files mentioned in the ptr.txt file eg: cat ptr.txt /home/abc.txt /home/pqr.txt /home/xyz.txt I have to read this pointer file and merge the files given in the pointer file so that final file say... (1 Reply)
Discussion started by: harshada
1 Replies

8. Shell Programming and Scripting

merge two files in one file

All, I've basic knowlege on understanding UNIX Shell Programming. Right now I need to write a script for the following requirement. Kindly help me or suggest me how to write a Shell script. I've 8 .csv files that are containing "Detail" records. Each file getting more than 1 million. Another... (3 Replies)
Discussion started by: nvkuriseti
3 Replies

9. Shell Programming and Scripting

merging two file in an ordered way

actually, it seems somewhat confusing.. let me clearify it i want a file having all the attributes produced by ls -lc command. i want to add one more thing i.e. time of last access to a file attribute. so how can i merge these two things in a single file in a columnar way. i tried with these... (2 Replies)
Discussion started by: raku05
2 Replies
Login or Register to Ask a Question