[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Remove randomly placed empty spaces

Posted on 2014-03-12
1
Medium Priority
?
121 Views
Last Modified: 2014-03-12
I have a query that produces a list of email addresses. Scattered throughout are erroneous empty spaces, such as myemailaddress @someserver.com. I need a query that takes the original list and spits the list out again but with no empty spaces in the address list. I'm a novice, so please be as detailed as possible. Thank you.
0
Comment
Question by:K_Deutsch
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 39923322
>erroneous empty spaces
coming from user input?
in which case, the user input should be secured, first, that such entries are not possible any longer.

after that, you may want to remove the spaces, knowing that extended email address like:
[guy hengel] guy.hengel@somedomain.com
would be a perfectly valid email address ...

select replace(your_email_field, ' ', '' ) from yourtable
http://www.techonthenet.com/access/functions/string/replace.php
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question