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
and 2: remove the space.
Thanks.
Chris
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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?
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?
J
John Vinson
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?
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]
J
Jason Lepack
LOL, no that's not a valid Postal Code. All Canadian Postal Codes are
in the form A0A 0A0.
in the form A0A 0A0.
J
John Vinson
LOL, no that's [GFY NFY] not a valid Postal Code. All Canadian Postal Codes are
in the form A0A 0A0.
Don't you mean L0L 7O7 then? <g>
John W. Vinson[MVP]