05-01-2011
thanks for those ideas,its works...but the problem appear when last word from a line is identical with first word from next line...any suggestions?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file that needs to be cleaned up. Here is the file:
Project
Project John
Project Gary
Project Sean
Project2
Project2 Lisa
Project2 Tyler
Project2 Sam
Project3
Project3 Mike
Project3 Bran
I need the o/p to be:
Project
John
Gary
Sean
Project2 (7 Replies)
Discussion started by: leepet01
7 Replies
2. SuSE
i have a problem in finding block of identical strings...i solved the problem in finding consecutive identical words and now i want to expand the code in order to find and remove consecutive identical block of strings...
for example the awk code removing consecutive identical word is:... (2 Replies)
Discussion started by: cocostaec
2 Replies
3. Programming
i have a problem in finding block of identical strings...i solved the problem in finding consecutive identical words and now i want to expand the code in order to find and remove consecutive identical block of strings...
for example the awk code removing consecutive identical word is:... (2 Replies)
Discussion started by: cocostaec
2 Replies
4. Shell Programming and Scripting
i have a problem in finding block of identical strings...i solved the problem in finding consecutive identical words and now i want to expand the code in order to find and remove consecutive identical block of strings...
for example the awk code removing consecutive identical word is:... (2 Replies)
Discussion started by: cocostaec
2 Replies
5. UNIX for Dummies Questions & Answers
Morning Guys & Gals,
I am trying to figure out a way to remove lines from a file that have more than
2 identical characters in sequence..
So if for instance the list would look like ;
the output would be ;
I can't seem to get my head around perl (among many other... (7 Replies)
Discussion started by: TAPE
7 Replies
6. Shell Programming and Scripting
Hi All,
I tried this but I am having trouble formulating this:
I have a file that looks like this (this is a sample file words can be different):
network
router
frame
network
router
computer
card
host
computer
card
One can see that in this file "network" and "router" occur... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
7. Shell Programming and Scripting
We have very large transaction logs that have transactions which start with a line that starts with 'Begin :' and ends with a line that starts with 'End :'. For most transactions there is valid data between those two lines.
I am trying to get rid of lines that look like this:
Begin :... (11 Replies)
Discussion started by: deneuve01
11 Replies
8. Shell Programming and Scripting
Mysql log has something like below:
I need a bash shell script that will do the following:
1) The script will scan the mysql.log file constantly in real time (something like tail -F mysql.log)
2) If it encounters 5 consecutive identical lines then it would invoke some commands (say... (4 Replies)
Discussion started by: proactiveaditya
4 Replies
9. Shell Programming and Scripting
Hi
I'd like to extract, from a text file, the strings starting with "The Thing" and only composed of words with a capital first letter and apostrophes, like for example:
"The Thing I Only" from "those are the The Thing I Only go for whatever."
or
"The Thing That Are Like Men's Eyewear" ... (7 Replies)
Discussion started by: louisJ
7 Replies
10. UNIX for Beginners Questions & Answers
I have some data that looks like this:
PXD= ZW< 1,6
QR> QRJ== 1,2(5)
QR> QRJ== 4,1(2)
QR> QRJ== 4,2
QRB= QRB 4,2
QWM QWM 6,2
R<C ZW< 11,2
R<H= R<J= 6,1
R>H XZJ= 1,2(2)
R>H XZJ= 2,6(2)
R>H XZJ= 4,1(2)
R>H XZJ= 6,2
RDP RDP 1,2
What I would like to do is if fields $1 and $2 are... (5 Replies)
Discussion started by: jvoot
5 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::mysql
SQL::ReservedWords::MySQL(3pm) User Contributed Perl Documentation SQL::ReservedWords::MySQL(3pm)
NAME
SQL::ReservedWords::MySQL - Reserved SQL words by MySQL
SYNOPSIS
if ( SQL::ReservedWords::MySQL->is_reserved( $word ) ) {
print "$word is a reserved MySQL word!";
}
DESCRIPTION
Determine if words are reserved by MySQL.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.
is_reserved_by_mysql3( $word )
Returns a boolean indicating if $word is reserved by MySQL 3.2.
is_reserved_by_mysql4( $word )
Returns a boolean indicating if $word is reserved by either MySQL 4.0 or 4.1.
is_reserved_by_mysql5( $word )
Returns a boolean indicating if $word is reserved by either MySQL 5.0 or 5.1.
reserved_by( $word )
Returns a list with MySQL versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_mysql3
is_reserved_by_mysql4
is_reserved_by_mysql5
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://dev.mysql.com/doc/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::MySQL(3pm)