[AccessD] Remove spaces from field

Mark,
 
Try:
Replace(Field1, " ", "")
 
HTH, 

Jim DeMarco 
Director of Product Development 
HealthSource/Hudson Health Plan 

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
Sent: Thursday, July 31, 2003 1:44 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Remove spaces from field



How can I remove any spaces from data in a field?

For example, Field1 contains 'johnsmith   01/01/1995 ABC'.  I want the field to be 'johnsmith01/01/1995ABC'.

Any suggestions?

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/f7bdd0a6/attachment-0001.html>