Shell Programming and Scripting

Hi
i elixir_sinari ran your commmand but it is not producing any output.
plz see below.
where extract.txt contain records just for e.g. i m running for two records that is 87 and 88 no from the file.

Code:

ckm1&cu158158:~/work/models/model/temp/shell > awk '$2+0>=06000000087' FS='SEQUENCE NUMBER: ' RS= extract.txt
ckm1&cu158158:~/work/models/model/temp/shell >

thanks,
prashant

---------- Post updated at 05:38 AM ---------- Previous update was at 05:33 AM ----------

itkamaraj your command is working fine but it is producing only sequence no but i want all the data like i posted in my second post.
e.g.

Code:

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EMDS/CREDIT SERVICES RunDate: 10/25/2011 REC# 1
SEQUENCE NUMBER: 06000000001 L90 KEY :060882D85800E201684C0000 CID KEY:000000000000000000
DEBT RATIO= 0% INQ W/I 6= 0, W/I 12= 0, W/I 18= 0, W/I 24= 0 ,PRM W/I 6=0; Trades RPTed W/I 24 = 0, No. of Trades = 3
*** FACT FRAUD CODE = ,FACT ALERT DATA CODE = 
XXXXXX XXXXX SSN-XXX-XX-XXXX C
XXXXXX,XXXXX. FAD: 0/00/0000 FILE SINCE: 0/00/0000
XXXXX XXXXXXXX XX XXXXXXXCA,92236
,,,,,,,,0
,,,,,,,,0
,,,,,,,,0
 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EMDS/CREDIT SERVICES RunDate: 10/25/2011 REC# 2
SEQUENCE NUMBER: 06000000002 L90 KEY :060882D85800E201684C0000 CID KEY:000000000000000000
 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EMDS/CREDIT SERVICES RunDate: 10/25/2011 REC# 2
SEQUENCE NUMBER: 06000000003 L90 KEY :060882D85800E201684C0000 CID KEY:000000000000000000
.
.
.
 
till 100 k
 
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EMDS/CREDIT SERVICES RunDate: 10/25/2011 REC# 2
SEQUENCE NUMBER: 06000100000 L90 KEY :060882D85800E201684C0000 CID KEY:000000000000000000
DEBT RATIO= 0% INQ W/I 6= 0, W/I 12= 0, W/I 18= 0, W/I 24= 0 ,PRM W/I 6=0; Trades RPTed W/I 24 = 0, No. of Trades = 3
*** FACT FRAUD CODE = ,FACT ALERT DATA CODE = 
XXXXXX XXXXX SSN-XXX-XX-XXXX C
XXXXXX,XXXXX. FAD: 0/00/0000 FILE SINCE: 0/00/0000
XXXXX XXXXXXXX XX XXXXXXXCA,92236
,,,,,,,,0
,,,,,,,,0
,,,,,,,,0

thanks

based on the given data....

Code:

 $ awk 'BEGIN{a=1}a{print;getline;print;getline;a=0}/SEQUENCE NUMBER: 06000000001/,/SEQUENCE NUMBER: 06000100000/{
if($0~/06000100000/){for(i=0;i<=7;i++){print;getline;}}}1' a.txt

hi itkamaraj thanks for updates.

some how i am geting error at the time of running your command.
awk: syntax error near line 1
awk: bailing out near line 1

and i am not getting why this error is coming.

thanks
prashant

try with nawk

hi itkamaraj,

i made small changes in your command that i changes sequence no and now i am fetching only first five record from a file which is having as of now 10 records using below command. But some how it is displaying all 10 records which is present into the extract.txt file.

nawk 'BEGIN{a=1}a{print;getline;print;getline;a=0}/SEQUENCE NUMBER: 56000000001/,/SEQUENCE NUMBER: 56000000005/{
if($0~/56000000005/){for(i=0;i<=7;i++){print;getline;}}}1' extract.txt

---------- Post updated at 09:59 AM ---------- Previous update was at 06:39 AM ----------

can anybody help me sort out the problem which i am facing?

i m running below command which is displaying all sequence no record from a file but i want only 2 sequence no from a file.

nawk 'BEGIN{a=1}a{print;getline;print;getline;a=0}/SEQUENCE NUMBER: 56000000001/,/SEQUENCE NUMBER: 56000000002/{
if($0~/56000000002/){for(i=0;i<=7;i++){print;getline;}}}1' extract.txt

Input file
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 1
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000001
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000001(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000002
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000002(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000003
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000003(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************

output file should be
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 1
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000001
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000001(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000002
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000002(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************

means it should display only two record out of 3.

try this...

Code:

$ nawk 'BEGIN{a=1}a{print;getline;print;getline;a=0}/SEQUENCE NUMBER: 56000000001/,/SEQUENCE NUMBER: 56000000002/{if($0~/56000000002/){for(i=0;i<=5;i++){print;getline}exit}}1' inp.txt
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 1
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000001
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000001(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxx REC# 3 PAGE: 2
xxxxxxx xxxxxxA SEQUENCE NUMBER: 56000000002
1 xxxxxxxxxxxxx xxxxxxxx#1000215 xxxxxx REC# 3 PAGE: 2
SEQUENCE NUMBER: 56000000002(CONT)
0*************************************************************************************************** *********************************
* **** xxxxxxxxxxxxxxxxxxxxxx **** *
**************************************************************************************************** ********************************

hi itkamaraj,

as you mentioned for loop for 5 line count and if we dont know the line count then what can be command?

prashant