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...
on.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 03, 2000 10:46 PM
To: [EMAIL PROTECTED]
Subject: removing space between words being uploaded to a database
This is a multi-part message in MIME format.
--=_NextPart_000_0021_01BFCE3C.048BE5A0
Content-Type: text/pl
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
Replace(myString," ","","ALL")
will remove all of the spaces, but
Replace(myString," "," ","ALL")
will remove the double spaces and change them to single space
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
4 matches
Mail list logo