pipe being in the string and then it'll be perfect. Either that or do a loop
over the RegEx and mid() the results directly into the DB rather than create a
list. Lots of potential avenues.
> damn but that is sweet. i've been sitting here for about an hour tweaking a
UDF that's well over 20 lines (so far). and it's still not done.
>
> MUST MUST MUST learn regexp...
>
>
> ----- Original Message -----
> From: Michael Dinowitz
> To: CF-Talk
> Sent: Monday, December 01, 2003 11:59 AM
> Subject: Re: The Last Space.
>
>
> <CFSCRIPT>
> string = "this is a test of of the emergency broadcast system. It is
only a
> test. If you expect this to go on and on, you are correct.";
> cut=REReplace(string, '(.{1,24} )', '\1|','all');
> </CFSCRIPT>
> Your string is now cut up into a list. Each list element (delimited by a
pipe)
> is at most 25 characters long and ends in a space. Using a loop over the
list
> will allow you to put each slice into the DB.
> Is this basically what you wanted?
>
> > Thanks, but this isn't for display purposes, it's to break long strings
into
> > multiple sub strings witch will each be inserted into a database. I have
to
> > live with size limits on the fields, but you can have multiple fields per
> > text. Go figure, but I have no control over database design, so I have to
> > live with the limitation.
> >
> >
> > --------------
> > Ian Skinner
> > Web Programmer
> > BloodSource
> > www.BloodSource.org
> > Sacramento, CA
> >
> > -----Original Message-----
> > From: Ubqtous [mailto:[EMAIL PROTECTED]
> > Sent: Monday, December 01, 2003 10:15 AM
> > To: CF-Talk
> > Subject: Re: The Last Space.
> >
> >
> > Ian,
> >
> > On 12/1/2003 at 13:02, you wrote:
> >
> > IS> Anybody know a trick (regex or otherwise) to find the position of
> > IS> the last white space character before an arbitrary limit?
> >
> > IS> In the following example, I want the position of the last white
> > IS> space before the 25th character.
> >
> > IS> "The quick brown fox jumped over a lazy dog."
> >
> > IS> So I would want the position of the white space after 'fox', which
> > IS> is the 20th character. This is the last white space before the
> > IS> 25th character with is the 'e' in 'jumped'. Allowing me to break
> > IS> the string into:
> >
> > IS> "The quick brown fox " <!-- note: trailing white space is
> > IS> included. --> "jumped over a lazy dog."
> >
> > Not the homemade solution you're looking for, but MX6.1's wrap()
> > function supposedly does 'smart' wrapping automatically:
> >
> > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca119.htm
> > <http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca119.htm>
> >
> > ~ Ubqtous ~
> > _____
> >
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
