In my table I imported from .txt, one of my columns has blank spaces.
The column is as follows, how do I eliminate the blank spaces in between the
second and third, and fifth and sixth digits?
12 345 6789
78 241 5869
04 258 3695
14 254 1136
00 045 0285
My whole column is formatted this way.
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200705/1 3  3754 
On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
In my table I imported from .txt, one of my columns has blank spaces.
The column is as follows, how do I eliminate the blank spaces in between the
second and third, and fifth and sixth digits?
12 345 6789
78 241 5869
04 258 3695
14 254 1136
00 045 0285
My whole column is formatted this way.
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!
HTH,
Jana
Jana, Thanx it worked... r, Shae
Jana wrote:
>On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
>In my table I imported from .txt, one of my columns has blank spaces.
[quoted text clipped - 11 lines]
>--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!
HTH,
Jana
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200705/1
On May 11, 1:51 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
Jana, Thanx it worked... r, Shae
Jana wrote:
On May 11, 1:03 pm, "ShaeMills via AccessMonster.com" <u33729@uwe>
wrote:
In my table I imported from .txt, one of my columns has blank spaces.
[quoted text clipped - 11 lines]
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
**TRY THIS ON A COPY OF YOUR TABLE FIRST!!**
Highlight the column that contains your data with spaces. In the Edit
menu, choose Replace. For the "Find What", enter a space. Leave the
"Replace With" field blank. Make sure the "Match Whole Field" is NOT
checked, and the "Search Only Current Field" IS checked. Click the
"Replace All" button, and voila!
HTH,
Jana
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...- Hide quoted text -
- Show quoted text -
Shae:
Glad I could help!
Jana This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jean-Marc Molina |
last post by:
Hello,
I can't find a way to execute a Windows application, whose directory path
contains blank spaces, from a PHP script. I also wonder if the problem
happens under Linux and other OS.
...
|
by: Ruben |
last post by:
Hello.
I am trying to read a small text file using the readline statement. I
can only read the first 2 records from the file. It stops at the blank
lines or at lines with only spaces. I have a...
|
by: mark |
last post by:
how to print, say 50 blank spaces, or say 20 blank spaces ?
I wanted use such blank spaces that can be output in a program at
predetermined places when printing with "cout".
|
by: MX1 |
last post by:
Hi,
I have a report with Name1 and Name2 in the address section . Sometimes,
Name2 is not populated with data via the query that feeds the report.
Unfortunately, the blank line stays in the...
|
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...
|
by: Nimmy |
last post by:
Hi,
How can I print blank spaces with printf()
I want something like printf("%6d %2d", lcVar1, lcVarb);
Printout should be:
123123 34
12 spaces in between 123123 and 34 and 15...
|
by: Laser Lu |
last post by:
Hi, all,
I'm now writing a program to compress JavaScript code. One puzzle is how
to write a regular expression to find out and remove all the redundent blank
spaces. However, those blank spaces...
|
by: SimonDev |
last post by:
Hi
I've got an unusual problem I'm hoping someone could advise me on, regarding
the formatting of the body of an HTTP response from a web service.
We are using HTTP POST rather than SOAP for...
|
by: maryanncanor |
last post by:
Hi everyone,
My problem is whenever I export a report to a textfile. The output textfile have blank spaces.
Here is my query:
SELECT ( & '|' & & '|'...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
