Serach and delete

kkm_job · #1 (**permalink**) 10-24-2006

Hi,
This is the format of the file that i have
CompanyNumber Run Date: 8/3/2006
6:22:15PM

Address:

Person: A03120
SP SNNu
100 1
200 2

CompanyNumber Run Date: 8/3/2006
6:22:15PM

Address:

Person: A03562

SP SNNu
100 1
200 2

i want to delete all the lines between CompanyNumber and Address: and add a new column called as person id to the o/p

this is the o/p that i need

Person SP SNNu
A03120 100 1
A03120 200 2

Person SP SNNu
A03562 100 1
A03562 200 2

Thanks
kk

jim mcnamara · #2 (**permalink**) 10-24-2006

try something like this :

Code:

#!/bin/ksh

sed '/^Company/,/^Address/d;/^$/d' filename |\
awk '{ if (match($0,"^Person")) { person=$2; print " "; printf "Person ";continue }
       print person, $0 
    }'

ranj@chn · #3 (**permalink**) 10-24-2006

Code:

sed '/^$/d' inpfilename | awk -f awkfile ;

where awkfile contains

Code:

/Person/ {
 i=0;
 name=$2
 getline; printf("%-10s%10s%10s\n", "Person", $1,$2);
 getline
 while($1 != "CompanyNumber" || $1 == "" )
 { 
  sp[i]=$1; snnu[i]=$2;
  i++;
  if(getline == 0) break;
 }
 for(cnt=0;cnt<i;cnt++)
 {
  printf("%-10s%10s%10s\n",name,sp[cnt],snnu[cnt]);
 }
 printf("\n");
}

anbu23 · #4 (**permalink**) 10-25-2006

Code:

awk '/^Person:/{
per=$2;getline title;
while(match(title,"^ *$")) getline title;
getline;
printf("Person %s\n",title);
printf("%s %s\n",per,$0);
getline;
printf("%s %s\n\n",per,$0);
}' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need to serach if a new line character exists on the last line in a file	sunilbm78	UNIX for Dummies Questions & Answers	10	02-29-2008 02:15 PM
serach and replace file name in the path in a remote xml file	kiranreddy1215	Shell Programming and Scripting	1	11-12-2007 11:31 AM
serach file using awk	mohan705	Shell Programming and Scripting	3	08-28-2007 11:04 AM
Case-insensitive serach with awk	acheepi	Shell Programming and Scripting	4	07-15-2005 05:58 PM
text serach in unknown file	ted	UNIX for Advanced & Expert Users	11	10-23-2003 03:20 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