Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Script to manipulate logfile text

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script to manipulate logfile text
# 8  
Old 12-02-2008
Ok one more question how would I modify the above if the format above was as such like below.

Code:
14/11/08 10:39:  Records allocated................ 221
14/11/08 10:39:  Records Freed.................... 0
14/11/08 10:39:  Records Aged..................... 20
14/11/08 10:39:  Records allocated................ 221
14/11/08 10:39:  Records Freed.................... 0
14/11/08 10:39:  Records Aged..................... 20

# 9  
Old 12-02-2008
Quote:
Originally Posted by rosspaddock
Could you possibly run me through what each line of the code is doing so i can alter it if need be regards ross
Ok, here we go:
Code:
awk '{
s=$1" , "substr($2,1,5)" , "$6
for(i=1;i<4;i++) {
  getline;s=s" , "$6
}
print s}' file

Code:
s=$1" , "substr($2,1,5)" , "$6

On the 1st, 5th, 9th line etc. assign field 1, the first 5 characters of the 2nd field and the 6th field to string s using " , " as delimiters.

Code:
for(i=1;i<4;i++) {
  getline;s=s" , "$6
}

Get the next 3 lines and add the 6th field after the string s.

Code:
print s

Print the string s and get the next line.
After printing the first string the next line is the 5th line since we have read 3 strings in the loop after the 1st string.

Regards
# 10  
Old 12-02-2008
Quote:
Originally Posted by rosspaddock
Ok one more question how would I modify the above if the format above was as such like below.

Code:
14/11/08 10:39:  Records allocated................ 221
14/11/08 10:39:  Records Freed.................... 0
14/11/08 10:39:  Records Aged..................... 20
14/11/08 10:39:  Records allocated................ 221
14/11/08 10:39:  Records Freed.................... 0
14/11/08 10:39:  Records Aged..................... 20

And what should be the output?

Regards
# 11  
Old 12-02-2008
Same format as before

14/11/08 , 10:39 , 221 , 0 , 20 , 221 , 0 , 20

thanks for all your help
# 12  
Old 12-02-2008
perl:

open FH,"<a.txt";
while(<FH>){
tr/\n//d;
my @temp=split(/ +/,$_);
my $str=sprintf("%s,%s",$temp[0],$temp[1]);
$hash{$str}=sprintf("%s,%s",$hash{$str},$temp[5]);
}
foreach $key (keys %hash){
print $key,$hash{$key},"\n";
}
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Manipulate condition to send mail based on output text in file

Hi All, I have a working script as below. echo "Files loaded with $(cat /var/tmp/script.X1.out)" | mail -s "Files loaded with return code" mailid This script takes the output from script.X1.out file and appends the text "Files loaded with return code" and sends the email. Now what I want... (5 Replies)
Discussion started by: midhun3108
5 Replies

2. UNIX for Beginners Questions & Answers

How to manipulate a text file and store each version for every changes in a directory?

I attached both picturehttps://1drv.ms/t/s!Aoomvi55MLAQh1jODfUxa-xurns_ and *.txt file of a sample work file. In this file Reactions which only start with "r1f", "r2f", "r3f"......and so on. And for each reaction the reaction rates is situated couple of lines later with a "+" sign. For each... (1 Reply)
Discussion started by: Atta
1 Replies

3. Shell Programming and Scripting

A better way to manipulate text

Good morning everyone, I'm currently trying to convert an environment variable into a string and then attach it at the end of a command and launch it. I have the following right now, but it's very ugly: AMI_TAGS="env=test,country=XX,city=blah,galaxy=blahblah" aws ec2 create-tags... (8 Replies)
Discussion started by: da1
8 Replies

4. UNIX for Beginners Questions & Answers

How can I remove partial duplicates and manipulate text?

Hello, How can I remove partial duplicates and manipulate text in bash using either awk, grep or sed? Thanks. Input: ted,"foo,bar,zoo" john-son,"foot,ben,zoo" bob,"bar,foot" Expected Output: foo,ted bar,ted zoo,ted foot,john-son ben,john-son (4 Replies)
Discussion started by: tara123
4 Replies

5. Shell Programming and Scripting

Manipulate the text file in UNIX

Hi All, I have a file like below and i have 2 questions on this (They are 3 lines starts with 01 , 02 and 03. but is 01abc333644554 234 2334535 34534535355353 sfsdf345455 353 4543 jgkg tty 7676 02cdesdfsdfsdf 234 wesdfsdf 345345 234234 234234 2342342 dfgdfg sdfgg dgdgdg fgvfs... (6 Replies)
Discussion started by: siva.pitchai
6 Replies

6. Shell Programming and Scripting

Logfile monitoring with logfile replacement

Bonjour, I've wrote a script to monitor a logfile in realtime. It is working almost perfeclty except for two things. The script use the following technique : tail -fn0 $logfile | \ while read line ; do ... some stuff done First one, I'd like a way to end the monitoring script if a... (3 Replies)
Discussion started by: Warluck
3 Replies

7. Shell Programming and Scripting

Need help to manipulate data using script

Hi i want to manipulate my data to convert row to column name 600 Slno vlan 1 600 2 609 3 700 name 700 Slno vlan 1 600 2 609 3 700 (8 Replies)
Discussion started by: nith_anandan
8 Replies

8. UNIX for Dummies Questions & Answers

Question on how to manipulate a SIMPLE text file (using awk?)

I have a simple txt files that looks something like this (The title is a part of the text file) Student Grades --------------- 1 Tim Purser 89 2 John Wayne 56 3 Jenn Hawkins 95 4 Harry Potter 75 Here are my questions: How would I ONLY print the names of students... (2 Replies)
Discussion started by: ninjagod123
2 Replies

9. Shell Programming and Scripting

manipulate text for openldap import/export question.

Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
Discussion started by: i2ambler
0 Replies

10. UNIX for Dummies Questions & Answers

using sed to manipulate text in files

Hi, I have a slight problem in trying to manipulate the text within a file using the "sed" command in that the text i need changed has "/" slashes in. I have a .sh script that scans the "/db/sybbackup/" directories for any .dmp file older than 2 days and then to >> the information to a file called... (3 Replies)
Discussion started by: Jefferson333
3 Replies
Login or Register to Ask a Question