Re: Remove a space from field data

Tech-Archive recommends: Speed Up your PC by fixing your registry

Me!

Thanks.

Tom Ellison


"John Nurick" <j.mapSoN.nurick@xxxxxxxxxxxxxx> wrote in message
news:goiou19htvdsb3lqjqf7oav8519a26cktq@xxxxxxxxxx
Hi Tom,

On Thu, 9 Feb 2006 23:13:26 -0600, "Tom Ellison" <tellison@xxxxxxxxxxx>
wrote:

What John says here is certainly a way to remove space(s) from your text.
However, in your examples, you removed the first space and left the
second.
That is not what this one does.

S = "123 456 789 ABC"
? Replace(S, " ", "", 1, 1)
123456 789 ABC

Am I missing something, or are you?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.



.

Relevant Pages

  • Re: Remove a space from field data
    ... However, in your examples, you removed the first space and left the second. ... 123456 789 ABC ... Am I missing something, or are you? ... Please respond in the newgroup and not by email. ...
    (microsoft.public.access.queries)
  • Re: sum up the column
    ... You are right on top of one of the major elements of ... identifying the Primary Key of your current table, ... Add the ABC column to this table. ... Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Remove a space from field data
    ... Use Instr to locate the first space in the string. ... A123 ABC and 1AB 123 whilst retaining the second blank space. ...
    (microsoft.public.access.queries)
  • Re: Remove a space from field data
    ... What John says here is certainly a way to remove spacefrom your text. ... However, in your examples, you removed the first space and left the second. ... Passing 1 as the fifth argument ensures that it ... A123 ABC and 1AB 123 whilst retaining the second blank space. ...
    (microsoft.public.access.queries)