format data

inquirer · #1 (**permalink**) 09-23-2003

i have this data:

Code:

GREEN LIST :
12321     34534
GREEN LIST :
45645 --- 23423
WHITE LIST :
23479     34534     75483     76924
12345 --- 12351     56778 --- 23330
GREEN LIST :
23567

the output must be:

Code:

GREEN LIST : 12321
GREEN LIST : 34534
GREEN LIST : 45645 --- 23423
WHITE LIST : 23479
WHITE LIST : 34534
WHITE LIST : 75483
WHITE LIST : 76924
WHITE LIST : 12345 --- 12351 
WHITE LIST : 56778 --- 23330
GREEN LIST : 23567

can you see what i mean? partially, i tried doing:

Code:

awk '
BEGIN { FS = "     " }
/LIST/ { tag = $1 ; next }
/[0-9]/ { print tag, $1 }' < filename

and it prints only the $1 but when i tried:

Code:

/[0-9]/ { print tag ; print $1 }' < filename

it works but the output is not what i wanted. :P

how can we do this

pls help

davidg · #2 (**permalink**) 09-24-2003

Your solution might be to first remove the new line after "LIST :". I think you know better how to do it than me. At least a newline is \n you should subsitute it with nothing.
Good luck.

Regs David

inquirer · #3 (**permalink**) 09-24-2003

i just used the following:

Code:


grep -E "LIST|^  [0-9]" ${1}  | sed 's/ --- /---/g' | sed 's/     / /g' |
awk '
/LIST/ { tag = $1 ; next }
/[0-9]/ { print tag , $0 }' > filter_out.log

cut -f1 -d" " filter_out.log > type_list.log

cut -f2 -d" " filter_out.log > field_one.log
cut -f3 -d" " filter_out.log > field_two.log
cut -f4 -d" " filter_out.log > field_three.log
cut -f5 -d" " filter_out.log > field_four.log

paste -d" " type_list.log field_one.log | grep "[0-9]" > out.txt
paste -d" " type_list.log field_two.log | grep "[0-9]"  >> out.txt 
paste -d" " type_list.log field_three.log | grep "[0-9]"  >> out.txt
paste -d" " type_list.log field_four.log | grep "[0-9]"  >> out.txt

although the output is something like:

Code:


GREEN 12321

instead of 

GREEN LIST : 12321

it works fine with me.

thanks anyway for the reply :P

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Shell script to format a .CSV data	Uday1982	Shell Programming and Scripting	8	02-04-2008 05:28 AM
how to number format a data file without using SED?	Cactus Jack	UNIX for Dummies Questions & Answers	3	01-12-2008 07:47 PM
Add data in days:hours:min:sec format	krishna_sicsr	Shell Programming and Scripting	1	03-17-2007 11:39 AM
data format from (4.56 0.7) -> 4.6(7) awk?!	ahan	Shell Programming and Scripting	4	05-07-2006 08:53 PM
kstat - format of output data?	ozvena	UNIX for Dummies Questions & Answers	4	06-16-2005 04:35 PM

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