|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Extracting words and lines based on keywords
Post 302818911 by seemad on Sunday 9th of June 2013 10:24:02 PM
06-09-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file which contains the following :
select * from test where test_id=1;
select id
from test1, test2 where test_id=1 and test_id=2;
select * from
test1, test2, test3 where test_id=4 and test2_id where in (select test2_id from test2);
select
id1, id2 from test ... (6 Replies)
Discussion started by: vrrajeeb
6 Replies
2. Shell Programming and Scripting
Hello everyone,
I am trying to write a script that will capture few lines from a text file based on 2 keywords in the first line and 1 keyword in the last one. It could also be based on the first line only + the folllowing 3 lines.
Could some one help or give directions. Thanks. (4 Replies)
Discussion started by: nimo
4 Replies
3. Shell Programming and Scripting
Hi,
anyone has any ideas on how do we extract lines from a file with format similiar to this: (based on current time)
Jun 18 00:16:50 .......... ............. ............
Jun 18 00:17:59 .......... ............. ............
Jun 18 01:17:20 .......... ............. ............
Jun 18... (5 Replies)
Discussion started by: faelric
5 Replies
4. Shell Programming and Scripting
Hi,
snp.txt
CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B
5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081
5 ... (12 Replies)
Discussion started by: genehunter
12 Replies
5. Shell Programming and Scripting
Extracting specific lines of data from a file and related lines of data based on a grep value range?
Hi,
I have one file, say file 1, that has data like below where 19900107 is the date,
19900107 12 144 129 0.7380047
19900108 12 168 129 0.3149017
19900109 12 192 129 3.2766666E-02
... (3 Replies)
Discussion started by: Wynner
3 Replies
6. Shell Programming and Scripting
i have something like this in a file called mysqldump.sql
--
-- Table structure for table `Table11`
--
DROP TABLE IF EXISTS `Table11`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Table11` (
`id` int(11) NOT NULL... (14 Replies)
Discussion started by: vivek d r
14 Replies
7. Shell Programming and Scripting
consider the following is the contents of the file
cat 11.sql
drop procedure if exists hoop1 ;
Delimiter $$
CREATE PROCEDURE hoop1(id int)
BEGIN
END
$$
Delimiter ;
.
.
.
.
drop procedure if exists hoop2;
Delimiter $$
CREATE PROCEDURE hoop2(id int)
BEGIN
END
$$ (8 Replies)
Discussion started by: vivek d r
8 Replies
8. Shell Programming and Scripting
the thing which i require is very very complex.. i tried hard to find the solution but couldnt..
the thing i need to achieve is say i have a file
cat delta.sql
CREATE VIEW Austin
Etc etc
.
.
.
CREATE VIEW Barabara
AS
SELECT blah blah blah
FROM Austin z, Cluster s, Instance i
WHERE... (4 Replies)
Discussion started by: vivek d r
4 Replies
9. Shell Programming and Scripting
Hi Guys,
I have the following problem. I have original file (org.txt) that looks like this
module v_1(.....)
//arbitrary number of text lines
endmodule
module v_2(....)
//arbitrary number of text lines
endmodule
module v_3(...)
//arbitrary number of text lines
endmodule
module... (6 Replies)
Discussion started by: kaaliakahn
6 Replies
10. Shell Programming and Scripting
hi
i have an input file that contains some thing like this
aaa acc aa abc1 1232 aaa abc2....
poo awq aa abc1 aaa aaa abc2
bbb bcc bb abc1 3214 bbb abc3....
bab bbc bz abc1 3214 bbb abc3....
vvv ssa as abc1 o09 aaa abc4....
azx aaq aa abc1 900 aqq abc19....
aaa aa aaaa abc1 899 aa... (8 Replies)
Discussion started by: anurupa777
8 Replies
LEARN ABOUT DEBIAN
apachetop
apachetop(1) USER COMMANDS apachetop(1) NAME
apachetop - display real-time web server statistics SYNOPSIS
apachetop [-f filename] [-H hits | -T time] [-q] [-l] [-s segments] [-p] [-r secs] DESCRIPTION
ApacheTop watches a logfile generated by Apache (in standard common or combined logformat, and generates human-parsable output in realtime. OPTIONS
-f logfile Select which file to watch. Specify this option multiple times to watch multiple files. -H hits | -T time These options are mutually exclusive. Specify only one, if any at all. They work as follows. ApacheTop maintains a table of informa- tion internally containing all the relevant information about the hits it's seen. This table can only be a finite size, so you need to decide how big it's going to be. You have two options. You can either: Use -H to say "remember <this many> hits" or Use -T to say "remember all hits in <this many> seconds" The default (at the moment) is to remember hits for 30 seconds. Setting this too large (whichever option you choose) will cause ApacheTop to use more memory and more CPU time. My experimentation finds that remem- bering no more than around 5000 requests works well. -q Instructs ApacheTop to keep the querystrings, not remove them. -l Instructs ApacheTop to lowercase all URLs, thus /FOO and /foo are treated as the same and accumulate the same statistics. -s segments Instructs ApacheTop to only keep the first <segments> parts of the path. Trailing slashes are kept if present. Statistics are then merged for each truncated url. -p Instructs ApacheTop to keep the protocol (http:// usually) at the front of its' referrer strings. Normal behaviour is to remove them to give more room to more useful information. -r secs Set default refresh delay, in seconds. EXAMPLES
apachetop -f /var/logs/httpd/access.log AUTHOR
Chris Elsworth <chris@shagged.org> SEE ALSO
http://www.webta.org/projects/apachetop/ version 0.10 February 13, 2004 apachetop(1)