script help needed --- awk?

scuderiaf1 · #1 (**permalink**) 06-19-2008

hello and thanks in advance.

I need to consolidate 2 records of data into 1 record.

here is a sample of the input:
------------------------------------------------------------------------------------------
totalcount fred thomas 99999.00 88888:00
total 77777.00
------------------------------------------------------------------------------------------
totalcount sally smither 99999.00 88888:00
total 77777.00 66666.00
------------------------------------------------------------------------------------------

Sample records are grouped within the '-------'. I need the data within the '---------' consolidated to look like the output format below

Fred, Thomas, 77777.00, 99999.00, 888888:00
Sally, Smither, 77777.00, 99999.00, 888888:00

zaxxon · #2 (**permalink**) 06-20-2008

If I got it right, just remove the ------ lines and the empty ones, right?

Code:

grep -vE "^------|^$" infile > newfile

scuderiaf1 · #3 (**permalink**) 06-20-2008

zaxxon

Yes that is one of the things needed. I now under stand the -v and -E args of grep. ty.

I still need to consolidate a couple of fields on each record in between the '------' to one record...... does that make sense?

I have a base awk statement that i have started. I piped your recommended grep command to it.

Code:

grep -vE "^------|^$" $FILENAME | awk '$4="04" { print $1","$2 }'

scuderiaf1 · #4 (**permalink**) 06-21-2008

I have a little time this morning to work on this script... any help would be appreciated. I will be posting the solution.

Go Ferrari!

ripat · #5 (**permalink**) 06-21-2008

Code:

awk 'BEGIN{RS="-+"; OFS=", "} $2 {print $2, $3, $7, $4, $5 }' your-file

scuderiaf1 · #6 (**permalink**) 06-21-2008

ty.... that works.

I am attempting to read/learn about the important parts of that script/command. Is is a true statement that awk considers everthing between the record seperator RS as one record?

Wow clean and simple.

Again thank you and regrards,

T

I've sat at the beginning of Eau Rouge. That circuit is in a magical place.

fpmurphy · #7 (**permalink**) 06-21-2008

A pure Korn shell solution

Code:

#!/usr/bin/ksh93

typeset -L1 -u firstF
typeset -L1 -u firstL

while read a b c d e
do
   if [[ $a == "totalcount" ]]; then
       nameF=$b
       nameL=$c
       numD=$d
       numE=$e
   fi
   if [[ $a == "total" ]]; then
       firstF=$nameF
       firstL=$nameL
       print "${firstF}${nameF#?}, ${firstL}${nameL#?}, $b, $numD, $numE"
   fi
done < file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
needed help in writing a script!	wrapster	Shell Programming and Scripting	5	06-13-2008 04:52 AM
Script needed	vpandey	Shell Programming and Scripting	3	03-04-2008 09:45 AM
Script information needed	chris1234	UNIX for Dummies Questions & Answers	3	12-17-2007 07:35 PM
help needed! my first script	fcbarcelona1984	Shell Programming and Scripting	1	11-04-2007 12:32 PM
Script Needed	Dastard	SUN Solaris	1	03-20-2007 10:54 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by