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)
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)
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)
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)
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)
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)
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)
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)
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 BSD
ptx
PTX(1) General Commands Manual PTX(1)NAME
ptx - permuted index
SYNOPSIS
ptx [ option ] ... [ input [ output ] ]
DESCRIPTION
Ptx generates a permuted index to file input on file output (standard input and output default). It has three phases: the first does the
permutation, generating one line for each keyword in an input line. The keyword is rotated to the front. The permuted file is then
sorted. Finally, the sorted lines are rotated so the keyword comes at the middle of the page. Ptx produces output in the form:
.xx "tail" "before keyword" "keyword and after" "head"
where .xx may be an nroff or troff(1) macro for user-defined formatting. The before keyword and keyword and after fields incorporate as
much of the line as will fit around the keyword when it is printed at the middle of the page. Tail and head, at least one of which is an
empty string "", are wrapped-around pieces small enough to fit in the unused space at the opposite end of the line. When original text
must be discarded, `/' marks the spot.
The following options can be applied:
-f Fold upper and lower case letters for sorting.
-t Prepare the output for the phototypesetter; the default line length is 100 characters.
-w n Use the next argument, n, as the width of the output line. The default line length is 72 characters.
-g n Use the next argument, n, as the number of characters to allow for each gap among the four parts of the line as finally printed.
The default gap is 3 characters.
-o only
Use as keywords only the words given in the only file.
-i ignore
Do not use as keywords any words given in the ignore file. If the -i and -o options are missing, use /usr/share/misc/eign as the
ignore file.
-b break
Use the characters in the break file to separate words. In any case, tab, newline, and space characters are always used as break
characters.
-r Take any leading nonblank characters of each input line to be a reference identifier (as to a page or chapter) separate from the
text of the line. Attach that identifier as a 5th field on each output line.
The index for this manual was generated using ptx.
FILES
/usr/bin/sort
/usr/share/misc/eign
BUGS
Line length counts do not account for overstriking or proportional spacing.
7th Edition October 22, 1996 PTX(1)