07-25-2005
filter parts of a big file using awk or sed script
I need an assistance in file generation using awk, sed or anything...
I have a big file that i need to filter desired parts only. The objective is to select (and print) the report # having the string "apple" on 2 consecutive lines in every report. Please note that the "apple" line has a HEX characters corresponding to it, that makes it really hard for me to filter this one out.
For simplicity, I used this sample file below. I appreciate all the help,as always....
thanks,
apalex
INPUT FILE:
-----------
REPORT #001
apple h'1
apple h'1
banana h'2
orange h'3
kiwi h'4
<
REPORT #002
apple h'1
banana h'2
orange h'3
kiwi h'4
<
REPORT #003
apple h'1
kiwi h'4
<
REPORT #004
apple h'1
apple h'1
banana h'2
orange h'3
<
REPORT #005
apple h'1
banana h'2
orange h'3
kiwi h'4
<
OUTPUT FILE (two "apple" in a report)
------------
REPORT OUTPUT #001
apple h'1
apple h'1
banana h'2
orange h'3
kiwi h'4
<
REPORT OUTPUT #004
apple h'1
apple h'1
banana h'2
orange h'3
<
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Morning guys. Another day another question. :rolleyes:
I am knocking up a script to pull some data from a file. The problem is the file is very big (up to 1 gig in size), so this solution:
for results in `grep "^\
... works, but takes ages (we're talking minutes) to run. The data is held... (8 Replies)
Discussion started by: dlam
8 Replies
2. Shell Programming and Scripting
Hi,
I need help with using an awk or sed filter on the below line
ALTER TABLE "ACCOUNT" ADD CONSTRAINT "ACCOUNT_PK" PRIMARY KEY ("ACCT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "WMC_DATA" LOGGING ENABLE
Look for... (2 Replies)
Discussion started by: rajan_san
2 Replies
3. Shell Programming and Scripting
Hi All,
I am very new in programming. I need some help.
I have one input file like:
Number of disabled taxa: 9
Loading mapping file: ncbi.map
Load mapping:
taxId2TaxLevel: 469951
--- Subsample reads (20%): 66680 of 334386
Processing: tree-from-summary
Running tree-from-summary algorithm... (9 Replies)
Discussion started by: iammitra
9 Replies
4. Shell Programming and Scripting
Hi
I need to to direct only the path and the name of the trace file to a new file. How do I use grep/awk/sed filter?
eg.
ABC.root>cat alert_omc_dg.log | grep trc
ORA-00060: Deadlock detected. More info in file /u01/oradata/omc/udump/omc_dg_ora_3555.trc.
ORA-00060: Deadlock detected. More... (8 Replies)
Discussion started by: geetap
8 Replies
5. Shell Programming and Scripting
I am afraid I don't understand awk well enough to do the following.
I have a file with a bunch of select statements where the a line starts off with this pattern:
"Last parsed SQL statement :", then continues with the select statement. At the first blank space I'd like it to stop, print that... (5 Replies)
Discussion started by: fwellers
5 Replies
6. Shell Programming and Scripting
Hi ,
I am trying to filter out the below output of fdisk -l command :
fdisk -l
Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 ... (9 Replies)
Discussion started by: omkar.jadhav
9 Replies
7. Shell Programming and Scripting
Hi,
i am trying to get the system model with the help of awk :
$ prtconf | awk '/^System Model/'
System Model: IBM,8408-E8D
but i want just the below outout that is command should chk for pattern <IBM,> and remove it from the final output :
System Model:8408-E8D
Can... (2 Replies)
Discussion started by: omkar.jadhav
2 Replies
8. Shell Programming and Scripting
Hi, I'm not very familiar witrh sed or awk and hope the somebody can help me to solve my problem. I need to filter a text report using grep, sed or awk. I would like to cut out text lines with the pattern INFO and if exists the following lines of the pattern DETAILS. I need te keep the lines with... (4 Replies)
Discussion started by: Frankg
4 Replies
9. Shell Programming and Scripting
I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
Discussion started by: MIA651
15 Replies
10. Shell Programming and Scripting
Hi, I have multiple files on a directory with the following content:
blahblah
blahblah
hostname server1
blahblah
blahblah
---BEGIN---
aaa
bbb
ccc
ddd
---END---
blahblah
blahblah
blahblah
I would like to filter all the files with awk or sed or something else so I can get below... (6 Replies)
Discussion started by: bayupw
6 Replies
LEARN ABOUT PHP
array_pop
ARRAY_POP(3) 1 ARRAY_POP(3)
array_pop - Pop the element off the end of array
SYNOPSIS
mixed array_pop (array &$array)
DESCRIPTION
array_pop(3) pops and returns the last value of the $array, shortening the $array by one element.
Note
This function will reset(3) the array pointer of the input array after use.
PARAMETERS
o $array
- The array to get the value from.
RETURN VALUES
Returns the last value of $array. If $array is empty (or is not an array), NULL will be returned.
ERRORS
/EXCEPTIONS
This function will produce an error of level E_WARNING when called on a non-array.
EXAMPLES
Example #1
array_pop(3) example
<?php
$stack = array("orange", "banana", "apple", "raspberry");
$fruit = array_pop($stack);
print_r($stack);
?>
After this, $stack will have only 3 elements:
Array
(
[0] => orange
[1] => banana
[2] => apple
)
and raspberry will be assigned to $fruit.
SEE ALSO
array_push(3), array_shift(3), array_unshift(3).
PHP Documentation Group ARRAY_POP(3)