You can use the following approach:
1) use the ReReplace function to replace all CR or CFLF with a single space
2) use the ReReplace function to replace all occurrences of 2 or more
consecutive spaces with a single space
You now have a list of words with a single space as the delimiter...
you can use any of the list functions or the CFLOOP tag specifying
space as the delimiter.
HTH
Dick
At 3:46 PM +1000 6/4/2000, AustralianAccommodation.com Pty. Ltd. wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0021_01BFCE3C.048BE5A0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>can I ask what the code is to remove spaces between words so that I can =
>update the database with the values minus the blank spaces
>
>
>Kind Regards
>
>Claude Raiola (Director)
>AustralianAccommodation.com Pty. Ltd.
>Website: www.AustralianAccommodation.com
>Email: [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
