Replace data in field

A

anil

hi all
I have data in field Site as
ABC-600-X-01,ABC-600-X-02,ABC-600-Y-01,PQR-601-X-01.
where ABC,PQR are the short name of towns and 600,601 are their codes
respectively.
There are around 200 records in field.

I used to import data in this format from various locations , e.g Town
ABC will send me in format ABC-600-X-01, ...so on and PQR will send in
PQR-601-X-01,....so on.

all data comes together at Center on paper and they enter in their
database and from there i recieve as .csv file.

Now from Center they have removed ABC,PQR and send it in format
600-X-01,600-X-02,601-X-01 and so on.

Is there any way so that I can fix it.
I have ABC and 600 both as seperate fields.

I hope I have made clear

thanks
anil
 
J

John Spencer

When you get a file from the "Center", does it contain data from both ABC
and PQR? Or is there a file for each town?

In other words, when you get a file, how do you know that a record (or the
file) relates to a specific town?
 
A

anil

Thanks John
It worked (with slight change).Although I have to change for 3-5 times
but I learned new thing,which was great.

Actually i was trying to figure out some thing like ---
" [TownTable].[TownLetters] & "-" & [CSVImportFile ].[SiteCode] "
but was not able.this also solved one of my old problem which I was
doing differently.
Thanks again
anil
 
Top