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]

Reply via email to