I have a field named address.
what i want to do is to split it into two:
making the last part of the address as the second part
example:
I have this address
#417 19673 MEADOW GARDENS WY
first part will be: # 417 19673 MEADOW GARDENS
second part will be: WY
JM Noval
Last Activity: Mar 15 '12, 02:12 PM
Joined: Feb 22 '12
Location:
-
How can I split my address data into two
-
I tried some codes to somehow get the right format for the names. my only problem now is this one..
Names with two initials..
For example this data: D&T CHICK
By using replace function,
I found a way to have it in this format: D. & T CHICK
What lacks now is a '.' on the initial T to make it: D. & T. CHICK
Is there a way to make it?
Really need help.. Thanks.. XD -
How to Manipulate Data upon Import
Hi everyone,
I need help once more.
I am working on an access database where I need to import raw data from an excel file.
What I needed to do is to append these data into a table which I named properties.
Under this table, I have a field named owner.
Now under the field owner, some of the data inputs are wrongly done or does not follow the supposedly correct format. What I wanted to do is to manipulate... -
Hi there once more neopa, I have tried what you suggested and it actually worked! thanks! The only Problem now is that some data are written in capital letters. What I would actually need to do is to change it to sentence case.
So for example,
the data 10653 KIMOLA WAY
What you have given replaces the data only to 10653-KIMOLA-WAY
when what I needed it to be like is 10653-Kimola-Way.
Thanks once...Leave a comment:
-
Thanks neopa, Ill try what you suggested..
I'm still trying to learn all this stuff so you've been a great help :)Leave a comment:
-
Hi neopa, Sorry I haven't clearly explained what needs to be done.
what I need to do actually is to import the address data (examples on top). It should be automatically populated during import by replacing the “spaces” in the “Address” field with “-“ (except the space between # and the unit apartment number. This space should be deleted.)Leave a comment:
-
Working with input mask on MS ACCESS 2007
hi! need help..
here's the sample data I need to mask
10653 KIMOLA WAY to
10653-Kimola-Way
here's another example:
# 1006 12069 Harris Rd to
#1006-12069-Harris-Rd
another example:
# 42 22308 124 AVE to
#42-22308-124-Ave
so the idea is
remove space between # and suite number
for example # 42 --->> #42;
remove the spaces in between...
No activity results to display
Leave a comment: