05-31-2007
grep with Regex help!
Hello everybody,
I'd like to know how is it I should write a regex in unix to match a string not followed by another string (anywhere in the line).
To be more specific, I want to find lines where "drop table" is found, but not followed anywhere in the line by the character "&".
For example,
I want to grep the line "drop table dbo.TAB_PUV_CR_0000692" in a file but not the line "drop table dbo.&1"
Thks a lot !!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
having a look on the regex site I saw that characters can be search using hex values
http://www.regular-expressions.info/characters.html
So I try to use it whith grep to find a è on a string (octal Decimal Hexa : 350 232 E8) but it doesn't work
E.g.
/usr/bin/echo '\0350' | egrep '\xE8'
... (0 Replies)
Discussion started by: solea
0 Replies
2. Shell Programming and Scripting
Hi,
I am trying to do something with grep, but for some reason I just can't get it to to work.
I am looking for find a match in the second field, the length must be 10 characters and end with 'abc'.
The file is in this format:
<int><tab><field2>
I've tried a few patterns, some work,... (2 Replies)
Discussion started by: iceman
2 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I'm a beginner with linux, regex, grep, etc
I am trying to get data out of a file that has about 13,000 lines in this format
name - location
I want to grep all the names out to one file and the locations to another so I can put them into a spreadsheet.
Some have hyphenated... (14 Replies)
Discussion started by: raichlea
14 Replies
4. Shell Programming and Scripting
basically i have a csv i parse through. a user will supply me with a san switch he/she wants more info about... say the name is "pnj-sansw124"
now i can grep out every connection to that switch w/o issue because this sans switch pnj-sansw124 has multiple slots 1-10. and it looks like this in the... (5 Replies)
Discussion started by: pupp
5 Replies
5. Shell Programming and Scripting
I want it to find lines that contain any number of capital letters before P
this is what I have tried
echo "AAAAAP" | grep 'P'
echo "AAAAAP" | grep '\{1\}P'
echo "AAAAAP" | grep '^*P'
But none of them seem to work, any help is much appreciated
thanks
Calypso (4 Replies)
Discussion started by: Calypso
4 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I'm working on unix with grep (GNU grep) 2.5.1. I'm going through some of the newer regex syntax using Regular Expression Reference - Advanced Syntax a guide.
ls -aLl /bin | grep "\(x\)"
Which works, just highlights 'x' where ever, when ever.
I'm trying to to get (?:) to work but... (4 Replies)
Discussion started by: MykC
4 Replies
7. Shell Programming and Scripting
How to match lines that don't contain a patern in regex it self, without using the -v option of grep? (15 Replies)
Discussion started by: vistastar
15 Replies
8. Shell Programming and Scripting
Hi to you all,
I'm just struggling with a regex problem and I'm pretty sure that I'm missing sth obvious... :confused:
I need a regex to feed my grep in order to find lines that contain one string but not the other.
Here's the data example:
2015-04-08 19:04:55,926|xxxxxxxxxx| ... (11 Replies)
Discussion started by: stresing
11 Replies
9. UNIX for Beginners Questions & Answers
Hello guys,
Here i am writing a script in bash to check for a valid URL from a file using regex
This is my input file
http://www.yahoo.commmmmm
http://www.google.com
https://www.gooogle.co
www.test6.co.in
www.gmail.com
www.google.co
htt://www.money.com
http://eeeess.google.com... (2 Replies)
Discussion started by: Meeran Rizvi
2 Replies
10. UNIX for Beginners Questions & Answers
Hi everyone,
I'm looking for a grep command to match the following pattern from a file:
<EGS>10234567<EGS>
I used this following command to do this:
grep -E '^<EGS>{8}<EGS>' test.txt
In output I got:
<EGS>10234567<EGS>
Till now it work, but if I add something at the end of the line... (2 Replies)
Discussion started by: Arnaudh78
2 Replies
LEARN ABOUT CENTOS
drop_table
DROP
TABLE(7) PostgreSQL 9.2.7 Documentation DROP TABLE(7)
NAME
DROP_TABLE - remove a table
SYNOPSIS
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TABLE removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table. To empty a table of
rows without destroying the table, use DELETE(7) or TRUNCATE(7).
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view
entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)
PARAMETERS
IF EXISTS
Do not throw an error if the table does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of the table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if any objects depend on it. This is the default.
EXAMPLES
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF
EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7)), CREATE TABLE (CREATE_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP TABLE(7)