At 12:44 AM 12/27/2003, Michael Stassen wrote:
You're welcome. I did suggest some (not very elegant) SQL in my first
note. I take it that didn't turn out to be useful. It's possible that if
you were to describe why not, someone could make a better suggestion. Of
course, I suppose you may hav
You're welcome. I did suggest some (not very elegant) SQL in my first
note. I take it that didn't turn out to be useful. It's possible that
if you were to describe why not, someone could make a better suggestion.
Of course, I suppose you may have already solved this in Delphi.
mos wrote:
C
Chris & Michael,
Thanks for the feedback. I was hoping it could be done in SQL without
using Perl since I don't have any experience with it. But I can use some
of the ideas you gave me to create a Delphi program quick enough. Thanks
again. :)
Mike
--
MySQL General Mailing List
For list ar
Michael Stassen wrote:
> You are right that perl can do the search and replace in one line, but
> you'll need some more code to read and write the data, either from <
> > mysql or from a source file before importing into mysql. That's
why I > said "almost" a one-liner.
>
> You are also right th
Chris W wrote:
Michael Stassen wrote:
mos wrote:
Ok, put your thinking caps on because this one bit of a toughie.
I an Update statement that will insert a '/' in front of the *first*
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".
Of course it doesn't always end in "ef"
Michael Stassen wrote:
mos wrote:
Ok, put your thinking caps on because this one bit of a toughie.
I an Update statement that will insert a '/' in front of the *first*
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".
Of course it doesn't always end in "ef" and could be an
mos wrote:
Ok, put your thinking caps on because this one bit of a toughie.
I an Update statement that will insert a '/' in front of the *first*
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".
Of course it doesn't always end in "ef" and could be any 2 or 3 group of
lette
Ok, put your thinking caps on because this one bit of a toughie.
I an Update statement that will insert a '/' in front of the *first*
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".
Of course it doesn't always end in "ef" and could be any 2 or 3 group of
letters like "AB