Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 03-07-2013
Registered User
 
Join Date: Feb 2008
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Fixed width file search based on position value

Hi,
I am unable to find the right option to extract the data in the fixed width file.


Code:
sample data 

abcd1234xgyhsyshijfkfk
hujk9876       io xgla
loki8787eljuwoejroiweo
dkfj9098           dja

Search based on position 8-9="xg" and print the entire row
output 

abcd1234xgyhsyshijfkfk

Thanks
onesuri
Sponsored Links
    #2  
Old 03-07-2013
anbu23's Avatar
anbu23 anbu23 is offline Forum Advisor  
Registered User
 
Join Date: Mar 2006
Location: Bangalore,India
Posts: 1,952
Thanks: 6
Thanked 79 Times in 77 Posts

Code:
$ awk ' substr($0,9,2) == "xg" ' file
abcd1234xgyhsyshijfkfk

Sponsored Links
    #3  
Old 03-07-2013
RudiC RudiC is offline Forum Advisor  
Registered User
 
Join Date: Jul 2012
Location: Aachen, Germany
Posts: 1,881
Thanks: 25
Thanked 434 Times in 420 Posts
The position of "xg" is 9-10 despite the phrasing in the spec. Try
Code:
$ grep -E "^.{8}xg" file
abcd1234xgyhsyshijfkfk

or
Code:
$ sed -En "/^.{8}xg/p" file
abcd1234xgyhsyshijfkfk

    #4  
Old 03-07-2013
ctsgnb ctsgnb is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Location: France
Posts: 2,763
Thanks: 72
Thanked 587 Times in 561 Posts

Code:
grep ^........xg yourfile
egrep ^.{8}xg yourfile

The Following User Says Thank You to ctsgnb For This Useful Post:
rbatte1 (03-07-2013)
Sponsored Links
    #5  
Old 03-07-2013
Registered User
 
Join Date: Jun 2007
Location: North-West UK
Posts: 521
Thanks: 73
Thanked 85 Times in 81 Posts
Dear ctsgnb,

What a fantastic and concise coding technique. I've fought with this for years, often cobbling some terrible script round it.



Wonderful.


Robin
Sponsored Links
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to split a fixed width text file into several ones based on a column value? bhanja_trinanja Shell Programming and Scripting 14 12-28-2010 02:15 PM
Remove duplicates based on a column in fixed width file Qwerty123 UNIX for Dummies Questions & Answers 1 07-15-2010 06:37 AM
row to column and position data in to fixed column width baluchen Shell Programming and Scripting 4 03-15-2010 06:46 AM
Append line based on fixed position ashikin_8119 Shell Programming and Scripting 2 03-19-2008 04:09 AM



All times are GMT -4. The time now is 04:59 AM.