Search and Replace

[Guest]

Hi
I have a field containing the following entires:
Train
Bus
Bus Train

I need to do a search and replace to repalce:
Train with T
Bus with B

This is fine but I also want Bus Train to be B Train and Then B T
How can I do this in just 2 replaces
I have tried the follwoing:
Bus with B
Train with T
*Bus*
HELP!! What I need to end up with is B and T and BT
Thank to all you whiz kids.

S

 

[Guest]

If this data is repeated so much that you are having to use a query to change
them becasue there is so many, maybe you should think about relating the
field to a new table called JourneyType which has these values in

If you create a query on the table where tha data is stored and pull up all
matches values that match Bus Train by entering "Bus Train" in the criteria.
Then go to the query menu and select update query. In the new row that
appears in the grid saying update to write "B T"

Repeat for the other to bits of information you want changed in the same way.

 

[Guest]

Hi
No it is just a one off so need to use a search and repalce - any ideas
please.

Regards.
S

 

[Guest]

Sorry but you seem to have not read my reply you can do as i said previously
if it is a one of operation.

If you create a query on the table where tha data is stored and pull up all
values that match Bus Train by entering "Bus Train" in the criteria.
Then go to the 'Query' menu and select 'Update Query'. In the new row that
appears in the grid saying 'Update To' write "B T"

Repeat for the other two bits of information you want changed, in the same
way.

You can then delete the query