Space Issue

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

If I have data that looks like this "VBG BNH" how do 1: locate these records
and 2: remove the space.

Thanks.
Chris
 
Sure sorry. These are Canadian zip codes and some have been coded without a
space VBBJHT and some have been coded with a space VFB GHT. I want to find
the ones that have a space and remove just the space. So VFB GHT would then
be VFBGHT. Can you help me?
 
Sure sorry. These are Canadian zip codes and some have been coded without a
space VBBJHT and some have been coded with a space VFB GHT. I want to find
the ones that have a space and remove just the space. So VFB GHT would then
be VFBGHT. Can you help me?
Click to expand...

Just to make Klatuu's suggestion run a bit faster, you can use a
criterion on the postcode field of

LIKE "* *"

to limit the update to those records which do contain a blank.

John W. Vinson[MVP]
 
LOL, no that's not a valid Postal Code. All Canadian Postal Codes are
in the form A0A 0A0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
Filter Records with a space at the beginning 3
Access Parking violations Access Database 0
Removing excess spaces in data 7
Update query Formatting 3
Windows 10 Insufficient disk space to fix volume bitmap. 5
NEXTINSPACE read all about it ------------ 0
Excel Hi, I want to add or remove spaces between initials in an Excel 2007 spreadsheet 0

Back
Top