help with removing extra letters from field(urgent)

  • Thread starter Thread starter Lauren
  • Start date Start date
L

Lauren

Hello, everyone. I am working on a sample database for
learning purposes. I want to remove the extra letters (xx)
from the field, which is Field2. Datasheet view. The word
Texas, it is spelled differently One way it is spelled is
Texasxx, another is Texxxas, and so forth. How am I to
remove the extra xx? Thank you for your assistance.
 
Hello, everyone. I am working on a sample database for
learning purposes. I want to remove the extra letters (xx)
from the field, which is Field2. Datasheet view. The word
Texas, it is spelled differently One way it is spelled is
Texasxx, another is Texxxas, and so forth. How am I to
remove the extra xx? Thank you for your assistance.
Click to expand...

YOu can use the Replace() function to do this. I think in another
thread you said that you were using A2002 (and please, keep questions
to the same thread rather than starting a new one!).

Update the field to

Replace([Field2], "xx", "")

This will find each instance of the string xx in Field2 and replace it
with a null string, and then update Field2 to the result.
 
OK, Thank You. I do have another question. What expression
would you use to remove spaces from a field.
I will keep to same thread, trying to help someone else.


-----Original Message-----
Hello, everyone. I am working on a sample database for
learning purposes. I want to remove the extra letters (xx)
from the field, which is Field2. Datasheet view. The word
Texas, it is spelled differently One way it is spelled is
Texasxx, another is Texxxas, and so forth. How am I to
remove the extra xx? Thank you for your assistance.
Click to expand...

YOu can use the Replace() function to do this. I think in another
thread you said that you were using A2002 (and please, keep questions
to the same thread rather than starting a new one!).

Update the field to

Replace([Field2], "xx", "")

This will find each instance of the string xx in Field2 and replace it
with a null string, and then update Field2 to the result.


.
Click to expand...
 
OK, Thank You. I do have another question. What expression
would you use to remove spaces from a field.
I will keep to same thread, trying to help someone else.
Click to expand...

A space is a character, just like x or * or _. If you wanted to
replace X by Y, you'ld use Replace(string, "X","Y").

So what would you use if you wanted to replace a space by something
else?
 
I think I made a mistake, what I need to know is, how to
remove all the spaces from the beginning of a field from a
table, In an update query.
Thank You for your patience. :)
 
Dear Lauren:

John seems to be away for a bit, so I'll jump in.

There is a function LTrim that returns a string without leading white
space and would likely be just what you want here.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
-----Original Message-----
Dear Lauren:

John seems to be away for a bit, so I'll jump in.

There is a function LTrim that returns a string without leading white
space and would likely be just what you want here.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts



.
Click to expand...
 
Back
Top