Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2013-01-01 Thread Kay C Lan
From my own experience; if you are trying to parse ANY SQL statement that
someone might enter, then NO, regex alone is not going to be your solution.
If on the other hand you are dealing with a relatively small subset of SQL
statements, maybe SELECT, UPDATE, DELETE, then regex would be able to very
quickly break these down into table/column names and values, etc etc.

Because SQL is so structured and strict (more so say than the 4.0 version
of html which is fairly loose in what it allows) it does lend itself to be
manipulated with regex.

HTH

On Sun, Dec 30, 2012 at 3:02 PM, Peter Haworth p...@lcsql.com wrote:

 Thanks Mark, more good resources.

 A question in the back of my mind now that I know enough about regexp to be
 dangerous.  Is parsing a language something that can be done with regular
 expressions?  I have a program in which I jumped though all sorts of hoops
 to parse SQL statements.  It works quite well but maintaining it is a pain.
  It feels like I could use regexps to separate the various clauses of a
 command, followed by other regexps to parse those clauses depending on
 type.

 Pete
 lcSQL Software http://www.lcsql.com


 On Sat, Dec 29, 2012 at 7:47 PM, Mark Laffoon mark.laff...@gmail.com
 wrote:

  I've always found RegExhibit from
  http://roger-jolly.nl/software/#regexhibithelpful.
  Also, for reference material,  http://www.regular-expressions.info/ has
  been of great help.
 
  Just my 2 cents.
  Mark
 
 
  --
  I am CDO. This is a lot like OCD, except the letters are in alphabetical
  order... as they should be.
  ___
  use-livecode mailing list
  use-livecode@lists.runrev.com
  Please visit this url to subscribe, unsubscribe and manage your
  subscription preferences:
  http://lists.runrev.com/mailman/listinfo/use-livecode
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2013-01-01 Thread Peter Haworth
These would be guaranteed valid SQLite statements so their syntax would be
exactly as documented, no errors.  SOunds like it might be worthwhile
spending a couple of hours with regex as an exercise to do this.
Pete
lcSQL Software http://www.lcsql.com


On Tue, Jan 1, 2013 at 5:10 AM, Kay C Lan lan.kc.macm...@gmail.com wrote:

 From my own experience; if you are trying to parse ANY SQL statement that
 someone might enter, then NO, regex alone is not going to be your solution.
 If on the other hand you are dealing with a relatively small subset of SQL
 statements, maybe SELECT, UPDATE, DELETE, then regex would be able to very
 quickly break these down into table/column names and values, etc etc.

 Because SQL is so structured and strict (more so say than the 4.0 version
 of html which is fairly loose in what it allows) it does lend itself to be
 manipulated with regex.

 HTH

 On Sun, Dec 30, 2012 at 3:02 PM, Peter Haworth p...@lcsql.com wrote:

  Thanks Mark, more good resources.
 
  A question in the back of my mind now that I know enough about regexp to
 be
  dangerous.  Is parsing a language something that can be done with regular
  expressions?  I have a program in which I jumped though all sorts of
 hoops
  to parse SQL statements.  It works quite well but maintaining it is a
 pain.
   It feels like I could use regexps to separate the various clauses of a
  command, followed by other regexps to parse those clauses depending on
  type.
 
  Pete
  lcSQL Software http://www.lcsql.com
 
 
  On Sat, Dec 29, 2012 at 7:47 PM, Mark Laffoon mark.laff...@gmail.com
  wrote:
 
   I've always found RegExhibit from
   http://roger-jolly.nl/software/#regexhibithelpful.
   Also, for reference material,  http://www.regular-expressions.info/has
   been of great help.
  
   Just my 2 cents.
   Mark
  
  
   --
   I am CDO. This is a lot like OCD, except the letters are in
 alphabetical
   order... as they should be.
   ___
   use-livecode mailing list
   use-livecode@lists.runrev.com
   Please visit this url to subscribe, unsubscribe and manage your
   subscription preferences:
   http://lists.runrev.com/mailman/listinfo/use-livecode
  
  ___
  use-livecode mailing list
  use-livecode@lists.runrev.com
  Please visit this url to subscribe, unsubscribe and manage your
  subscription preferences:
  http://lists.runrev.com/mailman/listinfo/use-livecode
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-31 Thread Robert Sneidar
Depends on the language. I tried making a Foxpro to Livecode parser once. I 
encountered situations where there was no good way to accomplish the 
translation. Also there are commands and functions in each language that have 
no equivalent in the other, and only another custom or function could 
accomplish the task. I gave up on it as either impossible, or else impractical. 
SQL is something that is quite parseable in simpler forms. Parsing complex 
joins would require a genius far beyond my paltry skills. If you have a good 
SQL parser that might be something you could make into a plugin. 

Bob


On Dec 29, 2012, at 11:02 PM, Peter Haworth wrote:

 Thanks Mark, more good resources.
 
 A question in the back of my mind now that I know enough about regexp to be
 dangerous.  Is parsing a language something that can be done with regular
 expressions?  I have a program in which I jumped though all sorts of hoops
 to parse SQL statements.  It works quite well but maintaining it is a pain.
 It feels like I could use regexps to separate the various clauses of a
 command, followed by other regexps to parse those clauses depending on type.
 
 Pete
 lcSQL Software http://www.lcsql.com
 
 
 On Sat, Dec 29, 2012 at 7:47 PM, Mark Laffoon mark.laff...@gmail.comwrote:
 
 I've always found RegExhibit from
 http://roger-jolly.nl/software/#regexhibithelpful.
 Also, for reference material,  http://www.regular-expressions.info/ has
 been of great help.
 
 Just my 2 cents.
 Mark
 
 
 --
 I am CDO. This is a lot like OCD, except the letters are in alphabetical
 order... as they should be.
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Richard Gaskin

Richmond wrote:


Maybe I'm missing something (nothing particularly unusual there), but . . .

I don't really get REGEX.

And,frankly, why on earth would I, or anyone else for that matter, want
to read through some awfully long, wordy and obscure load of b*mf about it?


There's nothing regular about regular expressions, and like so many 
things in computing they seem to have come about through a series of 
evolutionary steps which may well be characterized as accidents.


But it's the cryptic nature of regex that makes it so useful, providing 
a uniquely compact way of handling a vast range of text parsing in ways 
that would take many dozens of lines of code to do by any other means.


So whether we like regex or not, it's here to stay, useful and 
ubiquitous enough to be worth the learning curve.


That said, being a very generalized subsystem it's often not the fastest 
in execution speed in spite of being fast to type.


In many cases, writing a pull-parser or other offset-based function for 
a specific need will yield a much faster result than using regex.


The downside of not using regex, though, is the time required to write 
such functions every time you need 'em.  For performance-critical 
operations it's often well worth it, but for less critical routines 
regex may be the more productive option.


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Mark Wieder
Peter-

Saturday, December 29, 2012, 11:25:09 PM, you wrote:

 In this book I'm going to subversively teach you parsing, but I'm going to
 be very practical and straight forward about it. No NFA to DFA conversion.

Actually, I think NFA/DFA conversion is where regex gets really
interesting, but it's seriously arcane and mind-bogglingly difficult
to unravel.

-- 
-Mark Wieder
 mwie...@ahsoftware.net


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Robert Sneidar
I ran into a similar problem doing search and replace in word to clean up text 
from some data system destined for excel. My solution was often to replace a 
character or string I wanted to preserve with a placeholder, replace or remove 
what remains, then restore my placeholders with the original values. In 
situations like this, work with bigger strings first, and sometimes you need to 
work it end to beginning, especially if you are using a word or character 
counter to keep track of where you are. 

Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone

On Dec 30, 2012, at 2:23, Richmond richmondmathew...@gmail.com wrote:

 Those of you who don't want to feel faintly queasy had better tune out now.
 
 Theoretical / Pedagogical rant follows.
 
 
 
 Maybe I'm missing something (nothing particularly unusual there), but . . .
 
 I don't really get REGEX.
 
 And,frankly, why on earth would I, or anyone else for that matter, want to 
 read through
 some awfully long, wordy and obscure load of b*mf about it?
 
 --
 
 And the Wikipedia article:  http://en.wikipedia.org/wiki/Regex
 
 starts off by describing the blindingly obvious, and then tries to dress the 
 whole thing up in a load of jargon so
 some fancy academic can draw a fat salary for understanding the blindingly 
 obvious, and/or
 being capable of thinking in a straight line . . . but, hey, that seems to be 
 a universal problem.
 
 --
 
 What I do understand is that one needs a script(s) that looks for patterns in 
 a string and replaces
 them with other patterns, and that there needs to be a hierarchy of patterns.
 
 Consider my problem (apart from all the other ones, that is):
 
 I have a line of text in some funny language that goes like this;
 
 1aQngh1swnpQavh
 
 now there are the following considerations I have to deal with:
 
 1. Every time I encounter a '1' it has to be shunted after the char it 
 precedes.
 
 2. Every time I encounter a 'Q' it has to be shunted before a char it comes 
 after.
 
 3. 1aQ (this is what is known as the squirrel in the wood-pile (and I'm 
 sorry if I have offended any squirrels).
 
 Now a hierarchy of pattern recognition means I have to trap '1aQ'
 before I trap '1' and 'Q', because if I do things the other way round
 everything is going to be stewed squirrel to coin a phrase.
 
 Obviously there is the possibility that one might have to trap for '1*Q', 
 where '*' may be anything, and that adds
 a certain frisson to the whole thing.
 
 Now, where I come from, that is not called REGEX, that is called either 
 'logic' or 'getting things done in the right order'.
 
 --
 
 So, I sat down at my kitchen table with a pile of chess pieces (I have about 
 5 identical sets lying around)
 and lined them up in an order rather like '1aQngh1swnpQavh' and then, with 
 some more as 'my second text field'
 tried switching the things around - and after about 10 minutes everything 
 made reasonably good sense.
 
 And, as most programming seems to consist of getting things in the right 
 order (or, as a friend of mine once remarked
 getting things in the right ordure) that is about all there is to things.
 
 --
 
 Now you might be quite accurate in describing me as:
 
 1. Child-like.
 
 2. Not very good at abstract thought.
 
 But when one considers that about 95% of people are pretty much like that, 
 then
 maybe chess pieces on the kitchen table, and/or plastic cups with beans, are 
 not
 a bad way to go.
 
 
 
 Richmond.
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Richmond

On 12/30/2012 10:08 PM, Robert Sneidar wrote:

I ran into a similar problem doing search and replace in word to clean up text 
from some data system destined for excel. My solution was often to replace a 
character or string I wanted to preserve with a placeholder, replace or remove 
what remains, then restore my placeholders with the original values. In 
situations like this, work with bigger strings first, and sometimes you need to 
work it end to beginning, especially if you are using a word or character 
counter to keep track of where you are.

Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone




Well, I am doing perfectly alright with the pattern searching routine I 
worked
out with Unicode; as long as one works out which pattern to search for 
first,

second and so forth everything is comparatively straightforward.

This does not involve placeholders, nor anything else as bizarre.

Here's a text:

| abcdGfEhijGkElmnopGqrstuEvwxfyz |

and I know that I have to move 'E' forwards to before the letter that 
precedes it,


I know that I have to move 'G' to after the letter it follows,

and, I know that I have to replace 'f' with ''.

Now as 'G' and 'E' sometimes occur as 'doublets', vis 'GkE' I know that they
have to swap before worrying about single instances of either 'G' or 'E',
and that, as 'f' sometimes occurs in relation to either 'G' or 'E', or 
both of them,
I have to replace 'f' with '' after the other operations, otherwise 
they won't work.


So:

1. swap 'G' and 'E' when they surround one character.

2. move 'E' forwards by 1 when it occurs in isolation, and make sure
that precludes those 'E' chars that have already been swapped by rule #1.

3. Ditto for 'G'.

4. replace every instance of 'a' by ''.

One of the ways of avoiding falling over the results of rule #1 while 
implementing
#2 and #3 is to encode 'G' and 'E' in rule #1 as different symbols, say 
'%' and '@'
after processing so that rules #2 and #3 don't pick them up (one can 
always have
some rules #5 and #6 to replace '%' and '@' with 'G' and 'E' after 
running through

rules #2, #3 and #4).

Now the fun of the whole thing is that I have to do that sort of thing 
with texts that contain

about 20 patterns of the swap X with Y type.



Having worked out a way to do this in 2010 (and then being fairly stupid 
and forgetting the whole thing)
with Unicode putting the whole thing into practise has nothing at all to 
do with the strengths or
short-comings of Livecode, but the limitations of the human mind to get 
itself wrapped around the

underlying logic needed to work out the correct sequence of transformations.

Richmond.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Robert Sneidar
That is what I meant by placeholders. So long as you are 99.998% sure your 
placeholders cannot naturally occur in the source string, you're good. 

Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone

On Dec 30, 2012, at 12:31, Richmond richmondmathew...@gmail.com wrote:

 One of the ways of avoiding falling over the results of rule #1 while 
 implementing
 #2 and #3 is to encode 'G' and 'E' in rule #1 as different symbols, say '%' 
 and '@'
 after processing so that rules #2 and #3 don't pick them up (one can always 
 have
 some rules #5 and #6 to replace '%' and '@' with 'G' and 'E' after running 
 through
 rules #2, #3 and #4).

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Richmond

On 12/30/2012 10:44 PM, Robert Sneidar wrote:

That is what I meant by placeholders.


Aha; well we of little brain need a more explicit explanation :)


So long as you are 99.998% sure your placeholders cannot naturally occur in the 
source string, you're good.

Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone

On Dec 30, 2012, at 12:31, Richmond richmondmathew...@gmail.com wrote:


One of the ways of avoiding falling over the results of rule #1 while 
implementing
#2 and #3 is to encode 'G' and 'E' in rule #1 as different symbols, say '%' and 
'@'
after processing so that rules #2 and #3 don't pick them up (one can always have
some rules #5 and #6 to replace '%' and '@' with 'G' and 'E' after running 
through
rules #2, #3 and #4).

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-30 Thread Dr. Hawkins
On Sun, Dec 30, 2012 at 12:08 PM, Robert Sneidar slylab...@me.com wrote:
 I ran into a similar problem doing search and replace in word to clean up 
 text from
some data system destined for excel.

Also, when you need to do this, open in OpenOffice, which has most of
regexp search/replace.


-- 
Richard E. Hawkins, Esq.
(702) 508-8462

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-29 Thread Peter Alcibiades
Firefox plugin is decent.

A tutorial, very basic to start, but excellent and getting more
sophisticated as it goes along, here:

http://regex.learncodethehardway.org/book/

Recommended, even though it does start out assuming minimal knowledge.  

Peter



--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Help-with-Regex-was-Re-Switch-Case-and-wild-cards-tp4658429p4658457.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-29 Thread Peter Haworth
Thanks Peter, another weapon to add to my learning arsenal.
Pete
lcSQL Software http://www.lcsql.com


On Sat, Dec 29, 2012 at 12:14 PM, Peter Alcibiades 
palcibiades-fi...@yahoo.co.uk wrote:

 Firefox plugin is decent.

 A tutorial, very basic to start, but excellent and getting more
 sophisticated as it goes along, here:

 http://regex.learncodethehardway.org/book/

 Recommended, even though it does start out assuming minimal knowledge.

 Peter



 --
 View this message in context:
 http://runtime-revolution.278305.n4.nabble.com/Help-with-Regex-was-Re-Switch-Case-and-wild-cards-tp4658429p4658457.html
 Sent from the Revolution - User mailing list archive at Nabble.com.

 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-29 Thread Mark Laffoon
I've always found RegExhibit from
http://roger-jolly.nl/software/#regexhibithelpful.
Also, for reference material,  http://www.regular-expressions.info/ has
been of great help.

Just my 2 cents.
Mark


-- 
I am CDO. This is a lot like OCD, except the letters are in alphabetical
order... as they should be.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-29 Thread Peter Haworth
Thanks Mark, more good resources.

A question in the back of my mind now that I know enough about regexp to be
dangerous.  Is parsing a language something that can be done with regular
expressions?  I have a program in which I jumped though all sorts of hoops
to parse SQL statements.  It works quite well but maintaining it is a pain.
 It feels like I could use regexps to separate the various clauses of a
command, followed by other regexps to parse those clauses depending on type.

Pete
lcSQL Software http://www.lcsql.com


On Sat, Dec 29, 2012 at 7:47 PM, Mark Laffoon mark.laff...@gmail.comwrote:

 I've always found RegExhibit from
 http://roger-jolly.nl/software/#regexhibithelpful.
 Also, for reference material,  http://www.regular-expressions.info/ has
 been of great help.

 Just my 2 cents.
 Mark


 --
 I am CDO. This is a lot like OCD, except the letters are in alphabetical
 order... as they should be.
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-29 Thread Peter Alcibiades
I don't know, but this is what the author of the 'learn regex the hard way'
book has to say:-

/The key to using regular expressions correctly is to know where their
usefulness ends and when you need to bust out a lexer. You also need to know
where a lexer falls down and when a parser is the right tool. When you use
regular expressions to simplify creating lexers that feed into simple
parsers you then have a set of tools for cleaning and accurately parsing
text without going insane.

In this book I'm going to subversively teach you parsing, but I'm going to
be very practical and straight forward about it. No NFA to DFA conversion.
No crazy explanations of push down finite state automata. Just practical
code that gets you introduced to the basics of parsing, understanding the
core theory, and then actually using them to get work done./



Peter Haworth wrote
 A question in the back of my mind now that I know enough about regexp
 to be
 dangerous.  Is parsing a language something that can be done with regular
 expressions?  I have a program in which I jumped though all sorts of hoops
 to parse SQL statements.  It works quite well but maintaining it is a
 pain.
  It feels like I could use regexps to separate the various clauses of a
 command, followed by other regexps to parse those clauses depending on
 type





--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/Help-with-Regex-was-Re-Switch-Case-and-wild-cards-tp4658429p4658489.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-28 Thread Mike Bonner
The regex builder plugin in LC is pretty handy too and can help you work
things out in lc itself.  You can also be pretty sure of it works in the
builder, it will work in LC (though in all things, YMMV)


On Fri, Dec 28, 2012 at 3:07 PM, James Hale ja...@thehales.id.au wrote:

 Pete asked:
 Does anyone have any references to using regular expressions, preferable
 with lots of examples?

 If you are using a Mac i suggest getting yourself a copy of BBedit or its
 free sibling TextWrangler.
 I have never been much for using terminal commands and the like as I
 always preferred the Mac GUI so when it came to text manipulation I sought
 out easier tools. Nisus was my first taste of using regex with its token
 substitutions but when it when in to abeyance for a while I turned to
 BBedit.
 It allows the use of grep ( a command line regex tool) in its find and
 replace dialog and also does find and replace across multiple files. It's
 manual provides a good introduction to what you can do with regex, it is
 blindingly fast and a really easily way to try out different expressions.
 I found it invaluable when I wrote a web-scrapping app to provide a back
 end to my DVD collection many years ago. I still have times when I need to
 do a lot of text manipulation and will inevitably turn to BBedit's regex
 prowess to do the heavy lifting.
 As for references, there are lots on the web and O'Reilly have a couple of
 good books.
 But BBEDIT (or TextWrangler) will provide an easily accessible interface
 into using regex and trying out different things.

 James



 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-28 Thread Peter Haworth
Thanks James and Mike.  I am on a Mac and I think have TextWrangler
installed somewhere  so I can take a look at that.  The plugin is RegEx
Builder, right Mike?

The video tutorials I mentioned are really good since they are very
interactive and use lots of examples.  I already know how to validate an
email address and an ip address... not that I need to do either of those
things but the examples that show how to do it and explain it are really
useful.

Pete
lcSQL Software http://www.lcsql.com


On Fri, Dec 28, 2012 at 2:48 PM, Mike Bonner bonnm...@gmail.com wrote:

 The regex builder plugin in LC is pretty handy too and can help you work
 things out in lc itself.  You can also be pretty sure of it works in the
 builder, it will work in LC (though in all things, YMMV)


 On Fri, Dec 28, 2012 at 3:07 PM, James Hale ja...@thehales.id.au wrote:

  Pete asked:
  Does anyone have any references to using regular expressions, preferable
  with lots of examples?
 
  If you are using a Mac i suggest getting yourself a copy of BBedit or its
  free sibling TextWrangler.
  I have never been much for using terminal commands and the like as I
  always preferred the Mac GUI so when it came to text manipulation I
 sought
  out easier tools. Nisus was my first taste of using regex with its token
  substitutions but when it when in to abeyance for a while I turned to
  BBedit.
  It allows the use of grep ( a command line regex tool) in its find and
  replace dialog and also does find and replace across multiple files. It's
  manual provides a good introduction to what you can do with regex, it is
  blindingly fast and a really easily way to try out different expressions.
  I found it invaluable when I wrote a web-scrapping app to provide a back
  end to my DVD collection many years ago. I still have times when I need
 to
  do a lot of text manipulation and will inevitably turn to BBedit's regex
  prowess to do the heavy lifting.
  As for references, there are lots on the web and O'Reilly have a couple
 of
  good books.
  But BBEDIT (or TextWrangler) will provide an easily accessible interface
  into using regex and trying out different things.
 
  James
 
 
 
  ___
  use-livecode mailing list
  use-livecode@lists.runrev.com
  Please visit this url to subscribe, unsubscribe and manage your
  subscription preferences:
  http://lists.runrev.com/mailman/listinfo/use-livecode
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


Re: Help with Regex (was Re: Switch, Case and wild-cards?)

2012-12-28 Thread Mike Bonner
Yeah, its RegEx builder.

Feed it some text, and start typing in the regex and you get live feedback.
 It can be quirky but handy.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode