Combine reports and append a line between each


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Combine reports and append a line between each
# 1  
Old 11-07-2006
Combine reports and append a line between each

I am new to Unix and have tried to write a ksh script to do the following without success:

I have several reports in a directory (report1, report2, report3, etc). I would like to combine all of these reports into one file (REPORTS). I would like to append *** End of Report *** to each report so I can easily distinguish between each report in the file.

The output to the REPORTS file should look like:

report1
*** End of Report ***
report2
*** End of Report ***
report3
*** End of Report ***

Any help with this is greatly appreciated.
# 2  
Old 11-07-2006
Pretty simple....

Code:
$ cat > report1
This is report1
^D
$ cat > report2
This is report2
^D
$ cat > report3
This is report3
^D
$ for file in report*; do
>   cat $file >> REPORTS
>   echo "*** End Of Report ***" >> REPORTS
> done
$ cat REPORTS
This is report1
*** End Of Report ***
This is report2
*** End Of Report ***
This is report3
*** End Of Report ***

Cheers
ZB
# 3  
Old 11-08-2006
Thanks for the reply. I tried your suggestion ZB and I get the reports and then all of the ***End of Report*** messages at the end of the file:

report1
report2
report3
***End of Report***
***End of Report***
***End of Report***

This is the code that I now have:


#!/bin/sh

myhome=/ebizImpact/ImpactServer-5_4/config/Cluster/DOCfrFTP

# Move the Original .doc Word reports in DOCfrFTP/BAK to a tran file
# Add an End of Report seperator between each report

for FILE in $myhome/BAK/*.doc; do
cat -q $myhome/BAK/$FILE >> $myhome/DOCfrFTP_`date +%Y%m%d`.doc.tran
echo "*** END OF REPORT ***" >> $myhome/DOCfrFTP_`date +%Y%m%d`.doc.tran
done
rm -f $myhome/BAK/*.doc


The code is pretty simple so you would think it would work. Anyway, thanks again in advance for any further suggestions.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove new line starting with a numeric value and append it to the previous line

Hi, i have a file with multiple entries. After some tests with sed i managed to get the file output as follows: lsn=X-LINK-IN0,apc=661:0,state=avail,avail/links=1/1, 00,2110597,2094790,0,81,529,75649011,56435363, lsn=TM1ITP1-AM1ITP1-LS,apc=500:0,state=avail,avail/links=1/1,... (5 Replies)
Discussion started by: nms
5 Replies

2. Shell Programming and Scripting

Combine incrimental line

hi guys, i am writing a bash script.. that produce output some thing like this: road 100 300 500 road 100 300 500 road 100 300 500 road 100 300 500 street 400 200 700 street 400 200 700 path 200 100 900 i would like to combine all the entries that having the same but incremental (not... (12 Replies)
Discussion started by: pedot
12 Replies

3. Shell Programming and Scripting

Append Next line with current Line bassed on condition

Hi, I have an XML file and I am tring to extract some data form it, after lot of data cleaning process, I ended up with an issue, and need your urgent support. my current input data in below format: <Node>xxxxxx <Node>yyyyy</Node> <Node>zzzzzz <Node>12345</node> I need... (9 Replies)
Discussion started by: rramkrishnas
9 Replies

4. Shell Programming and Scripting

Combine multiline to one line till a blank line

Hello, I have a file as :- ABC DEF GHI JKL <BlankLine> MNO PQR STU VWX <BlankLine> YZA I need it as below:- ABCDEFGHIJKL; MNOPQRSTUVWX; (3 Replies)
Discussion started by: jassi10781
3 Replies

5. UNIX for Dummies Questions & Answers

How to remove fields space and append next line to previous line.?

awk 'BEGIN{FS = "Ç"} NR == 1 {p = $0; next} NF > 1 {print p; p = $0} NF <= 1 {p = (p " " $0)} END {print p}' input.txt > output.txt This is what the input data file looks like with broken lines Code: 29863 Ç890000000 Ç543209911 ÇCHNGOHG Ç000000001 Ç055 ... (4 Replies)
Discussion started by: cumeh1624
4 Replies

6. Shell Programming and Scripting

find a certain line and append text to the end of the line

After I create printer queues in AIX, I have to append a filter file location within that printers custom file. within lets say test_queue.txt I need to find the row that starts with :699 and then I need to append on the end the string /usr/local/bin/k_portrait.sh. Now I've gotten the sed... (2 Replies)
Discussion started by: peachclift
2 Replies

7. Shell Programming and Scripting

Append next line to previous line when one pattern not found

Hi, I need help for below scenario.I have a flat file which is having records seperated by delimiters which will represent each record for oracle table.My Control file will consider each line as one record for that table. Some of the lines are aligned in two/three lines so that records are... (4 Replies)
Discussion started by: kannansr621
4 Replies

8. Shell Programming and Scripting

Combine line before the pattern

Hi, I am not very familiar with sed and awk and i have a huge file to process which is impossible to do manually. I want to print out beginning from "Network" until end of line only (excluding the Version). AND. the decription to be all in one line. File: Version: 2.0 Network: xxx... (9 Replies)
Discussion started by: The One
9 Replies

9. UNIX for Dummies Questions & Answers

combine files line by line

Hi all, I once knew of a simple unix command to do this, but I can't remember it and I can't find it by searching. I have two files. ### FILE A #### A1 A2 A3 A4 A5 ### FILE B #### B1 B2 B3 B4 B5 (2 Replies)
Discussion started by: Digby
2 Replies

10. Shell Programming and Scripting

Joining lines in reverse. append line 1 to line 2.

Hi I have used many times the various methods to append two lines together in a file. This time I want to append the 1st line to the second and repeat for the complete file.... an example This is the file owns the big brown dog joe owns the small black dog jim What I want is ... (7 Replies)
Discussion started by: dwalley
7 Replies
Login or Register to Ask a Question