append an output file with two columns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting append an output file with two columns
# 1  
Old 10-16-2010
append an output file with two columns

Hi All, can you help me with this:
grep XXX dir/*.txt|wc -l > newfile.txt - this put the results in the newfile.txt, but I want to add another column in the newfile.txt, string 'YYYYY', separated somehow, which corresponds on the grep results?
For example grep will grep XXX dir/*.txt|wc -l > newfile.txt will look like:

ABVC

and I want to add the string 'YYYYY' in order to become:

ABVC YYYYY

Thanks in advance!
Atanas
# 2  
Old 10-16-2010
Try...
Code:
 
grep XXX dir/*.txt|awk 'END{print NR,"YYYYY"}' > newfile.txt

And how about just this...
Code:
 
awk '/XXX/{Cnt++}END{print cnt,"YYYYY"}' dir/*.txt > newfile.txt

# 3  
Old 10-16-2010
Code:
grep XXX dir/*.txt|wc -l

does not produce ABVC

Could you be more specific about what you are looking for?

Last edited by Scrutinizer; 10-16-2010 at 06:10 AM..
# 4  
Old 10-16-2010
Sorry scrutiniser, my mistake...ABVC should be XXX
Thanks malcomex999, but it doesn't work. When I try with the first statement, below is exactly what I write:
grep Event ME_MOBILEROAM_POST_20101015*|wc -l|awk 'END{print NR,"YYYYY"}' > counter.txt - the result is 1 YYYYY, but should be 1792 YYYYY, it seems that wc -l doesn't work
Second statement:
awk '/Event/{Cnt++}END{print cnt,"YYYYY"}' ME_MOBILEROAM_POST_20101015* > counter.txt - the result is YYYYY, but should be 1792...actually I can't see where to count here....may be I explained not so good what I need ...Smilie
Atanas
# 5  
Old 10-16-2010
Quote:
Originally Posted by apenkov
awk '/Event/{Cnt++}END{print cnt,"YYYYY"}' ME_MOBILEROAM_POST_20101015* > counter.txt
Watch out for red once above and figure it out...
# 6  
Old 10-17-2010
Thanks a lot!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need solution to compare two file and update and append the output

Hi All, I have two files File1 frame,007C1 server1_Parent frame,007C3 server2_Silver frame,007EE server3_Bronze frame,00855 server4_Parent frame,00856 server4_Parent frame,00858 server5_Parent frame,008FA server6_Silver frame,008FB server6_Silver frame,008FC server6_Silver... (2 Replies)
Discussion started by: ranjancom2000
2 Replies

2. Shell Programming and Scripting

Append to a file repeating output

Hello, i'm trying to force a command to read every second from an interface watch -n1 (command) /dev/x | cat >> output but it continue to overwrite the file, without append the content Thanks and advace for help as usual regards (4 Replies)
Discussion started by: Board27
4 Replies

3. Shell Programming and Scripting

awk dynamically append columns into file

Hi, I have a large data file, want to separate it into 100 part and export one specific field as a file; then I want to append each part's column into one file. How to realize that? 1 2 3 1 2 3 4 2 2 3 4 3 3 3 4 4 3 4 5 5 3 4 5 6 I want the last column of the data file, e.g divide it... (5 Replies)
Discussion started by: wanliushao
5 Replies

4. Shell Programming and Scripting

How to print and append output of nawk script in commandline and as well into a file?

Hi All, I am working on nawk script, has the small function which prints the output on the screen.Am trying to print/append the same output in a file. Basically nawk script should print the output on the console/screen and as well it should write/append the same result to a file. script :... (3 Replies)
Discussion started by: Optimus81
3 Replies

5. UNIX for Dummies Questions & Answers

Noob questions.. Append output to a file in different directory

Noob question! I know almost nothing so far, and I'm trying to teach myself from books, on a typical command line without using scripts how would I append output from a sort to a file in a completely different directory? example: If I'm sorting a file in my documents directory but I... (2 Replies)
Discussion started by: Byrang
2 Replies

6. Shell Programming and Scripting

problem with print append to output file syntax

I'm trying to output the contents of the infile to the outfile using Append. I will want to use append but the syntax doesn't seem to be working ! Input file (called a.txt) contains this: a a a b b b I'm running shell script (called k.sh) from Unix command-line like this: ./k.sh .... (1 Reply)
Discussion started by: script_op2a
1 Replies

7. UNIX for Dummies Questions & Answers

Append file with grep output but add timestamp?

I've setup a cron job that greps a file every five minutes and then writes (appends) the grep output/result to another file: grep "monkey" zoo.log | tail -1 >> cron-zoo-log Is there any way I can add the date and time (timestamp) to the cron-zoo-log file for each time a new line was added? ... (12 Replies)
Discussion started by: Sepia
12 Replies

8. UNIX for Dummies Questions & Answers

Output to file but append rather than overwrite?

I am running a command which has a parameter that outputs the results to a file each time it is run. Here is the command: --fullresult=true > importlog.xml Can I add the output to the file rather than creating a new one which overwrites the existing one? If not can I make the file name... (2 Replies)
Discussion started by: Sepia
2 Replies

9. Shell Programming and Scripting

Append Output to another file in Perl

Hi All, I am writing a Perl script such that the output from "perl myscript.pl file1" to be appended to another file name called file2. I tried out with the below code but couldn't work. Can any expert give me some advice? open(OUTPUT, 'perl myscript.pl file1 |'); close OUTPUT;... (7 Replies)
Discussion started by: Raynon
7 Replies

10. Shell Programming and Scripting

Append output to file

Hi, I have a script below. It get's the data from the output of a script that is running hourly. My problem is every time my script runs, it deletes the previous data and put the current data. Please see output below. What I would like to do is to have the hourly output to be appended on the... (3 Replies)
Discussion started by: ayhanne
3 Replies
Login or Register to Ask a Question