Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Retrieve the record using 2,2 lines and display the ouput in columnwise

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Retrieve the record using 2,2 lines and display the ouput in columnwise
# 1  
Old 06-23-2011
Retrieve the record using 2,2 lines and display the ouput in columnwise
This is my file
-------------
Code:
Using index 8 for dump of table abd_det. (6101)
Dumped 0 records. (13932)
Using index 10 for dump of table abscc_det. (6101)
Dumped 0 records. (13932)
Using index 14 for dump of table absc_det. (6101)
Dumped 254365 records. (13932)
Using index 16 for dump of table absd_det. (6101)
Dumped 0 records. (13932)
Using index 18 for dump of table absi_mstr. (6101)
Dumped 0 records. (13932)
Using index 19 for dump of table absl_det. (6101)
Dumped 0 records. (13932)
Using index 21 for dump of table absr_det. (6101)
Dumped 66359 records. (13932)

I want the output like this:
-------------------------
Code:
abd_det - 0
abscc_det-0
absc_det-254365
absd_det-0
absi_mstr-0
absl_det-0
absr_det-66359

Last edited by Franklin52; 06-23-2011 at 04:53 AM.. Reason: Please use code tags for data and code samples
# 2  
Old 06-23-2011
Code:
perl -ln0e 'while (/table (\w+).*\nDumped (\d+)/g){print "$1 - $2"}' file

# 3  
Old 06-23-2011
Code:
 
nawk ' /Using index/{printf ("%s - ",$8);getline;print $2}' test
abd_det. - 0
abscc_det. - 0
absc_det. - 254365
absd_det. - 0
absi_mstr. - 0
absl_det. - 0
absr_det. - 66359

# 4  
Old 06-23-2011
Another one:
Code:
awk -F"[. ]" '/Using/{printf $(NF-2) " - "} /Dumped/{print $2}' file

# 5  
Old 06-23-2011
Code:
awk -F "[. ]" '{printf (NR%2?$(NF-2):"-" $2 RS)}' infile

# 6  
Old 06-23-2011
Sed way..
Code:
sed '/_/{N;s/.* \(.*\)\. [^ ]* \([0-9]*\) .*/\1-\2/}' inputfile > outfile

# 7  
Old 06-23-2011
Lot of Thanks for all the inputs.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

awk command to retrieve record 23 and 89 from UNIX file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file?... (6 Replies)
Discussion started by: rakeshp
6 Replies

2. UNIX for Beginners Questions & Answers

awk command to retrieve record 23 and 89 from UNIX file

Hi Everyone, I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file? Please let me know what is the awk command for this? Regards Rakesh (1 Reply)
Discussion started by: rakeshp
1 Replies

3. Shell Programming and Scripting

Help with keep the first record display

Input file: 10 TMP_12 asdg 13 TMP_12 asdg 123 TMP_12 pasf 123 ASD qwe 224 AW4 asrfwe 524 AW4 2342 724 AW4 poimv 241 AW4 oiljs . . Desired output file: 10 TMP_12 asdg 13 TMP_12 asdg 123 ASD qwe 224 AW4 asrfwe . (2 Replies)
Discussion started by: perl_beginner
2 Replies

4. Shell Programming and Scripting

how to retrieve lines that the first 4 columns have different values

Hi, all: I am not familiar with unix,and just started awk scripts. I want to retrieve lines that have the first 4 columns with different values. For example, the input is like this (tab delimited file with one header) r1 A A A A x r2 A B B A x r3 B B B B x the output should be (header is... (15 Replies)
Discussion started by: new2awkin2011
15 Replies

5. Shell Programming and Scripting

Retrieve lines from a file in a given date range

Hey, guys! I am trying to retrieve lines from a file in a given date range. I tried using sed -n "/${SDATE}/,/${EDATE}/p" ~/webhits/$FILE | wc -l but that doesn't work if the starting or the end date do not match exactly. If both dates match, there are no problems (for example 25 March 2008 -... (5 Replies)
Discussion started by: oopcho
5 Replies

6. Shell Programming and Scripting

have to retrieve the distinct values (not duplicate) from 2nd column and display

I have a text file names test2 with 3 columns as below . We have to retrieve the distinct values (not duplicate) from 2nd column and display. I have used the below command but giving some error. NS3303 NS CRAFT LTD NS3303 NS CHIRON VACCINES LTD NS3303 NS ALLIED MEDICARE LTD NS3303 NS... (16 Replies)
Discussion started by: shirdi
16 Replies

7. Programming

How can i retrieve some specific lines from a file using C

Plz tel me how to retrieve some specific set of lines from a file and store it in a char buffer.I am seperating each record by ":" 22:abc:4 hardware:cd:xyz:2 hardware:eth:abc:6 hardware:mouse:xyz:3 hardware:ram:xyz:1 23:cde:3 hardware:cd:xyz:2 hardware:eth:abc:6 hardware:ram:xyz:1 ... (3 Replies)
Discussion started by: vigneshinbox
3 Replies

8. UNIX for Dummies Questions & Answers

retrieve lines using sed, grep or awk

Hi, I'm looking for a command to retrieve a block of lines using sed or grep, probably awk if that can do the job. In below example, By searching for words "Third line2" i'm expecting to retrieve the full block starting with 'BEGIN' and ending with 'END' of the search. Example: ... (3 Replies)
Discussion started by: learning_linux
3 Replies

9. Shell Programming and Scripting

Script to display record spanning over multiple lines

Following are the lines from /etc/sudoers.conf bob SPARC = (OP) ALL : SGI = (OP) ALL fred ALL = (DB) NOPASSWD: ALL ALL CDROM = NOPASSWD: /sbin/umount /CDROM,\ /sbin/mount -o nosuid\,nodev /dev/cd0a /CDROM Could you please help me with shell/perl script to display the records with... (2 Replies)
Discussion started by: Ujan
2 Replies

10. UNIX for Dummies Questions & Answers

retrieve lines that match a pattern

Hi, I would like to know how can I get lines from a text file that match no more than 2 '>'. Example: Input file: a >cr1 4 a>b b>c a >cr2 5 a>b Output file: a >cr2 5 a>b Thanks in advance (2 Replies)
Discussion started by: fadista
2 Replies
Login or Register to Ask a Question