Script on pattern matching and print lines and export to excel - Shell Programming and Scripting

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Script on pattern matching and print lines and export to excel

google unix.com

Thread: Script on pattern matching and print lines and export to excel

View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->

#4 (permalink)

06-25-2009

shaliniyadav shaliniyadav is offline

Registered User

Join Date: Jun 2009

Posts: 30

Thanks a lot... It did work after i use the below line

Code:

nawk 'c&&c-- {if (c==5 ||c==1||c==0) printf $0 ((c==0)?ORS:OFS);next} /^*RTF$/ {c=7}' BSC01_CHARKOP.COMBINED > aa1

But output is:

Code:

BCCH 4 0 4 6 9 106 1351 77
BCCH 4 0 4 6 9 106 1352 68
NON_BCCH 4 0 4 6 9 106 1351 87
NON_BCCH 4 0 4 6 9 106 1351 113
NON_BCCH 4 0 4 6 9 106 1351 122
NON_BCCH 4 0 4 6 9 106 1352 112
NON_BCCH 4 0 4 6 9 106 1352 119
NON_BCCH 4 0 4 6 9 106 1352 124
NON_BCCH 4 0 4 6 9 106 1352 756

I wanted something like this :

Code:

BCCH-4 0 4 6 9 106 1351-77
BCCH-4 0 4 6 9 106 1352-68
NON_BCCH-4 0 4 6 9 106 1351-87-113-122
NON_BCCH-4 0 4 6 9 106 1352-112-119-124

Thanks and Regards
Shalini

Last edited by Yogesh Sawant; 06-29-2009 at 05:50 AM.. Reason: added code tags