awk or grep ??


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk or grep ??
# 1  
Old 01-17-2008
Error awk or grep ??

Hi All,

I need to creat one cutdown file from one full file. The full file may looks as below:

UHL1 08007 DDLIST 000
O301107121212A & L TRANSFER IN ALCB ...................
A301107121212720000IBACS LIAISON ...................
O060807138202B O C THE DIRECT DEBIT DEPT...........
A060605138202404356IBOC MANCHESTER ACC......................
O301106202001ZEUS ADMINISTRATION SERVICES SU BRODIE ....
A301106202001400250IFIRST ADVICE ...................
O060807214209COMMERCIAL UNION LIFE ASSURANCE FRANCIS JACKSON ..................
A060605214209400250ICGU CU CUDDNCS ..............
A060605214209400250ICGU CU CUI-IS DD ..........
O120607232323A & L TRANSFER IN Karina Armstrong ....
A120607232323720000IBACS LIAISON ...................
O130707241010AULD PROPERTIES LTD RAYMOND AULD .......
UTL1064600


I need to extract only lines which starts from "O" to my cutdown file from full file.
Also from this selected lines (which has "O") I need only few position fields.
Position for these fields from full file are (from 8-13),(from 14-30) and (from 36-40).
And each cutdown file record should start with "DTL1".

Finally my cutdown file should look like below:
DTL121212A & L TRANSFER IN ALCB........
DTL1138202B O C THE DIRECT DEBIT DEPT......
.
. etc.,


I know how to select the lines with "O" using grep. But I dont know how to insert DTL1 to each line and also how to select position for this.

I know this can be implemented in awk easily, but Iam not much exposure to awk.

Pls help me achieve this...
# 2  
Old 01-17-2008
Hi,

Am also very new to awk.
But the below command can work out a part of ur query
awk '/^O/ { print "DTL1" $1 }' <filename>
The above command gives the o/p as below:
DTL1O301107121212A
DTL1O060807138202B
DTL1O301106202001ZEUS
DTL1O060807214209COMMERCIAL
DTL1O120607232323A
DTL1O130707241010AULD

As ur file doesnot have any coloumn separator Am not aware of how to print the positional paramaeters.

if there is a space inbetween two strings in a file , then awk consider it as two different arguments.Hence "O301107121212A" is the first argument and "&" "L" "TRANSFER" "IN" "ALCB" are the 2nd 3rd etc arguments.

Regards,
Jisha
# 3  
Old 01-17-2008
There is something wrong with your specification for the fields you want outputted.
Your sample output is variable length but you specify fixed field lengths.
# 4  
Old 01-17-2008
Hope this is what you are looking for...

grep "^O" file | cut -c 8-13,14-30,36-40 | while read line ; do echo DTL1$line ;done

o/p as per your data:
DTL1121212A & L TRANSFER IN ....
DTL1138202B O C THE DIRECT DEPT
DTL1202001ZEUS ADMINISTRATIRVICE
DTL1214209COMMERCIAL UNION ASSUR
DTL1232323A & L TRANSFER INna Ar
DTL1241010AULD PROPERTIES LYMOND


-ilan
# 5  
Old 01-17-2008
Quote:
Originally Posted by ilan
Hope this is what you are looking for...

grep "^O" file | cut -c 8-13,14-30,36-40 | while read line ; do echo DTL1$line ;done

o/p as per your data:
DTL1121212A & L TRANSFER IN ....
DTL1138202B O C THE DIRECT DEPT
DTL1202001ZEUS ADMINISTRATIRVICE
DTL1214209COMMERCIAL UNION ASSUR
DTL1232323A & L TRANSFER INna Ar
DTL1241010AULD PROPERTIES LYMOND


-ilan
Thats perfect ilan.
Thanks
Jisha
# 6  
Old 01-17-2008
And here is the same solution using sed

Code:
sed -n -e 's/\(^O.\{6\}\)\(.\{23\}\)\(.\{5\}\)\(.\{5\}\)\(.*$\)/DTLI\2\4/p' file

# 7  
Old 01-17-2008
Code:
sed -n -e "s/^O.\{6\}\(.\{23\}\).\{5\}\(.\{5\}\).*/DTL1\1\2/p" input.txt

Edit: fpmurphy beat me to it Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Using awk instead of grep -f

Hi Guys. I am trying to count occurances of patterns(occurance can be anywhere in file2) from file1 in file2. file1 is god god pod rod file2 is iamgod iamgod podrod 123rod456 output should be god 2 god 2 pod 1 rod 2 I am not good at awk but i figured out this command.it doesnt... (7 Replies)
Discussion started by: ahfze
7 Replies

2. Shell Programming and Scripting

sed and awk usage to grep a pattern 1 and with reference to this grep a pattern 2 and pattern 3

Hi , I have a file where i have modifed certain things compared to original file . The difference of the original file and modified file is as follows. # diff mir_lex.c.modified mir_lex.c.orig 3209c3209 < if(yy_current_buffer -> yy_is_our_buffer == 0) { --- >... (5 Replies)
Discussion started by: breezevinay
5 Replies

3. UNIX for Dummies Questions & Answers

Piping grep into awk, read the next line using grep

Hi, I have a number of files containing the information below. """"" Fundallinfo 6.3950 14.9715 14.0482 """"" I would like to grep for Fundallinfo and use it to read the next line? I ideally would like to read the three numbers that follow in the next line and... (2 Replies)
Discussion started by: Paul Moghadam
2 Replies

4. Shell Programming and Scripting

awk / grep

how do I change this line to use the awk command RC19=`grep -c "Broken pipe" $FTP_OUT` Code tags please (5 Replies)
Discussion started by: mbmarciniak
5 Replies

5. Shell Programming and Scripting

AWK/GREP: grep only lines starting with integer

I have an input file 12.4 1.72849432773174e+01 -7.74784188610632e+01 12.5 9.59432114416327e-01 -7.87018212757537e+01 15.6 5.20139995965960e-01 -5.61612429666624e+01 29.3 3.76696387248366e+00 -7.42896194101892e+01 32.1 1.86899877018077e+01 -7.56508762501408e+01 35 6.98857157014640e+00... (2 Replies)
Discussion started by: chrisjorg
2 Replies

6. Shell Programming and Scripting

Read content between xml tags with awk, grep, awk or what ever...

Hello, I trying to extract text that is surrounded by xml-tags. I tried this cat tst.xml | egrep "<SERVER>.*</SERVER>" |sed -e "s/<SERVER>\(.*\)<\/SERVER>/\1/"|tr "|" " " which works perfect, if the start-tag and the end-tag are in the same line, e.g.: <tag1>Hello Linux-Users</tag1> ... (5 Replies)
Discussion started by: Sebi0815
5 Replies

7. Shell Programming and Scripting

Is it better to grep and pipe to awk, or to seach with awk itself

This may just be a lack of experience talking, but I always assumed that when possible it was better to use a commands built in abilities rather than to pipe to a bunch of commands. I wrote a (very simple) script a while back that was meant to pull out a certain error code, and report back what... (4 Replies)
Discussion started by: DeCoTwc
4 Replies

8. Shell Programming and Scripting

MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else

Hi Guys, I need to set the value of $7 to zero in case $7 is NULL. I've tried the below command but doesn't work. Any ideas. thanks guys. MEM=`ps v $PPID| grep -i db2 | grep -v grep| awk '{ if ( $7 ~ " " ) { print 0 } else { print $7}}' ` Harby. (4 Replies)
Discussion started by: hariza
4 Replies

9. UNIX for Dummies Questions & Answers

grep and awk

I have grep MHz psrinfo-v.out it gives The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, The i386 processor operates at 3000 MHz, how to get instead of these 4 lines: CPU speed: 3000 MHz i.e. CPU... (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

10. Shell Programming and Scripting

[grep awk cut] > awk

Hi, I'm very new to scripting. grep $s $filename | awk '{print $2}' | cut -c 1-8 How can I optimize this using a single awk? I tried: awk '/$s/ {print $2}' $filename | cut -c 1-8 However didn't work, I think the awk is not recognizing $s and the verbal is something else. (6 Replies)
Discussion started by: firdousamir
6 Replies
Login or Register to Ask a Question