Visit Our UNIX and Linux User Community


Need help on appending info from one file to other side by side


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help on appending info from one file to other side by side
# 1  
Old 11-09-2009
Need help on appending info from one file to other side by side

Hi All,

I have a file abc.xls which contains data
applciation usage
merlin 24000
hermes 48000

and my script generates an output to a file def.xls
applciation usage
merlin 23000
hermes 50000
Daily i want to schedule this script to run and I need the second column to be appended to the file abc .xls
the output would be like
applciation usage usage
merlin 24000 23000
hermes 48000 50000
next day...
applciation usage usage usage
merlin 24000 23000 2300012
hermes 48000 50000 2300098
etc....


How can i implement this can any one pls suggest

Thanks very much in advance

---------- Post updated at 03:04 PM ---------- Previous update was at 02:52 PM ----------

The scripts which I tried for the above are as follows
szur0849pap:merlinprd% cat Prod_Huffs.sh
#!/bin/ksh
. /home/gaddamja/Huffs_Report.sh >>/home/gaddamja/Temp1
cat /home/gaddamja/Temp1 | awk '{print $1}' >>/home/gaddamja/def.txt

szur0849pap:merlinprd% cat Prod_Huffs_Status.sh
#!/bin/ksh
cd /home/gaddamja
paste def.txt >>/home/gaddamja/abc.xls
echo "Hi All,\n">>/home/gaddamja/Temp
echo "PFA Prod huffs usage as of now( `date`):">>/home/gaddamja/Temp
echo "\n\n\nRegards,">>/home/gaddamja/Temp
echo "Jagadish.">>/home/gaddamja/Temp
/usr/bin/uuencode Prod_Huffs_Utilisation.xls Prod_Huffs_Utilisation.xls >>/home/gaddamja/Temp
cat /home/gaddamja/Temp | /usr/ucb/mail -s "Huffs Report" jagdish-chandra-bose.gaddam@ubs.com
rm Temp
# 2  
Old 11-09-2009
have you tried 'join' (see 'man join') ?
# 3  
Old 11-09-2009
I got it with the below,Its working

redirecting it to a file and renaming the output file with the same file for next days run

#!/bin/ksh
cd /home/gaddamja
paste Prod_Huffs_Utilisation.xls Temp2 >/home/gaddamja/Prod_Huffs_Utilisation1.xls
echo "Hi All,\n">>/home/gaddamja/Temp
echo "PFA Prod huffs usage as of now( `date`):">>/home/gaddamja/Temp
echo "\n\n\nRegards,">>/home/gaddamja/Temp
echo "Jagadish.">>/home/gaddamja/Temp
/usr/bin/uuencode Prod_Huffs_Utilisation1.xls Prod_Huffs_Utilisation.xls >>/home/gaddamja/Temp
cat /home/gaddamja/Temp | /usr/ucb/mail -s "Huffs Report" jagdish-chandra-bose.gaddam@ubs.com
mv Prod_Huffs_Utilisation1.xls Prod_Huffs_Utilisation.xls
rm Temp


But again my doubt is why not
paste Prod_Huffs_Utilisation.xls Temp2 >/home/gaddamja/Prod_Huffs_Utilisation.xls is working..

cant we redirect the output to same file in unix ?

thanks n advance

Previous Thread | Next Thread
Test Your Knowledge in Computers #589
Difficulty: Medium
A binary search algorithm requires that the array being searched is sorted in descending order.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to run 2 python scripts at the same time side by side on the same line?

Could I run 2 python scripts at the same time side by side output on the same line in this same format but with scripts? from itertools import izip_longest with open("file1") as textfile1, open("file2") as textfile2: for x, y in izip_longest(textfile1, textfile2, fillvalue=""): x =... (4 Replies)
Discussion started by: bigvito19
4 Replies

2. Shell Programming and Scripting

How to print contents side by side of a file ?

Hi Team, I have input like Input file.txt Contents: Total: 939720704 bytes Total: 521142272 bytes Total: 262144 bytes Total: 786432 bytes Total: 9043968 bytes Total: 9371648 bytes I need out put like the content of file should be side by side.that is 1st line beside... (3 Replies)
Discussion started by: rocking77
3 Replies

3. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

4. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies

5. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies

6. Web Development

Cannot access Apache web server from Wan side, only Lan side.

I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network. Been through several setup tutorials so far, no dice still. For testing purposes I have... (1 Reply)
Discussion started by: davidmanvell
1 Replies

7. 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

8. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

9. Shell Programming and Scripting

How to print two sql query outputs side by side in excel

Hi, I have to sql queries like select sno,sname from temptable; select deptno,dname from depttable; In excel i want to specify the column number to which my output should be displayed. please help me in this... thanks in advance... (6 Replies)
Discussion started by: prasee
6 Replies

10. UNIX for Dummies Questions & Answers

Having a Unix system installed side to side with Windows?

Atm i have Windows 98. Can i install a Unix system like Redhat on my computer, and on boot choose which one to go to? Like i can with Win95 & 98... Please help me. I dont know alot about unix so im still learning. I just know its better than Win for the internet and it doesnt crash. :) (14 Replies)
Discussion started by: Pcslider
14 Replies

Featured Tech Videos