[AccessD] Remove spaces from field

Jim DeMarco Jdemarco at hshhp.org
Thu Jul 31 12:50:10 CDT 2003


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>


More information about the AccessD mailing list