The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com



UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Script to search a bad record in a file then put the record in the bad file shilendrajadon Shell Programming and Scripting 2 12-28-2007 10:02 AM
Script to search a bad record in a file then put the record in the bad file shilendrajadon UNIX for Advanced & Expert Users 1 12-28-2007 10:00 AM
splitting a record and adding a record to a file rsolap Shell Programming and Scripting 1 08-13-2007 01:58 PM
read record from file koti_rama Shell Programming and Scripting 3 08-08-2007 01:02 AM
How to exclude a record from unix file Ryan2786 UNIX for Dummies Questions & Answers 1 06-27-2007 02:16 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 05-16-2008
raoscb raoscb is offline
Registered User
  
 

Join Date: May 2008
Posts: 16
Thumbs down how to read record by record from a file in unix

Hi guys,
i have a big file with the following format.This includes header(H),detail(D) and trailer(T) information in the file.My problem is i have to search for the character "6h" at 14 th and 15 th position in all the records .if it is there i have to write all those records into a separate file along with the header and trailer and the last nine digits in the trailer should indiacate the count of the detaied records.can any one help me on this how to achive? Basically i am new to unix shell scripting.

following the file format is

HBM6303000000000200805060940412008050609404120080506SCITS 8.2
D6303200805066HJ8164-61002 EURO6303I0073554514 0017992008031120080430HP00DD00Hewlett-Packard Pte Ltd 12.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022797990001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022797990001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018052008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798050001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798050001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018142008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798140001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798140001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018092008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798090001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798090001
TBM630300000000020080506094041000003818

advancedthanks
narasimha.
  #2 (permalink)  
Old 05-16-2008
era era is offline Forum Advisor  
Herder of Useless Cats (On Sabbatical)
  
 

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 3,652
Code:
awk '/^H/ { h=$0; next }
/^T/ { if (p) print; p=0; next }
substr($0,14,2) == "6h" { if (h) print h; if (d) print d; print; h = d = ""; p=1; next }
{ h = d = ""; p=0; }' file
With only a single example to test with, it's hard to know if this correct. Apparently all the D lines in an entry will have "6H" (not "6h")?
Sponsored Links
Closed Thread

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 07:38 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language translation by Google.
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0