473,322 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Remove spaces from a set of numbers

How can i remove the spaces from the group of numbers below?
11 222 33 4444 555

This is an access DB table and it's a field named JOIN_PNUM
I need to make the number look like:
11222334444555.
Mar 23 '10 #1
2 1789
Atli
5,058 Expert 4TB
Moved to the Access forum. Please try to post your questions in the appropriate forms. Thanks.
Mar 23 '10 #2
missinglinq
3,532 Expert 2GB
Where are you trying to do this? In a Form? In a Query?

The simplest way would be to create a be to create Query based on your table, with a calculated field based on JOIN_PNUM.

How you do this will need to be based on the version of Access you're running.

With version 2003 or later, something like
Expand|Select|Wrap|Line Numbers
  1. NEW_JOIN_PNUM: Replace([JOIN_PNUM], " ","")
Now simply use the Query as the base for your forms/reports and use NEW_JOIN_PNUM in place of JOIN_PNUM.

Welcome to Bytes!

Linq ;0)>
Mar 23 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Ellen K. | last post by:
In a previous post I mentioned having a problem getting leading spaces to be written to SQL Server using OPENXML. They showed up fine in my XML documents if I printed them, but not in my database....
3
by: Dante | last post by:
I need a regular expression to remove all spaces from a string. The best I could do was this: var spacefix = / /gi; var out = data.replace(spacefix,""); Thanks so much, Dante.
1
by: Suresh | last post by:
formName: Name of the form ctrlListBox: Name of the Listbox control function fnRemoveListItem(formName, ctrlListBox) { if (formName == '') var formName = document.forms(0).name obj =...
1
by: Danny | last post by:
Given this: "*" the pattern to remove the htnl code between brackets, how can I remove a series of spaces and just make one space. like here is a series of blank...
22
by: fynali | last post by:
Hi all, I have two files: - PSP0000320.dat (quite a large list of mobile numbers), - CBR0000319.dat (a subset of the above, a list of barred bumbers) # head PSP0000320.dat CBR0000319.dat...
3
by: Danny Yeadon | last post by:
Hi I need to remove unwanted characters from phone numbers from my phone bill to analyse the data. Some examples are 02 48222222 i need to remove the space +61266667656 ...
7
by: Mike Johnson | last post by:
How do I remove a item that's been selected from a listview? I'm using Visual Basic 2005 express edition. Thanks
15
by: DanielJohnson | last post by:
I am writing a program in which I am removing all the spaces from the string. I thought that I could do it two ways. One was parsing the string character by character and copying onto another...
2
by: hyperlez | last post by:
Hey all I have a column of user membership ids that is 8 characters long. These ids are based on the users surname with number added on the end to uniquely identify each user. My problem is...
2
by: prasadshete | last post by:
hey guys ,plz help me out to remove numbers in the name of the out put string.. i am new to PHP..i have to fetch the name from database. and in some name numbers and spaces are available and i wnat...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.