Solved

Remove randomly placed empty spaces

Posted on 2014-03-12
1
108 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

735 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