Find and Replace

[Keibri]

Hi guys,



I was wondering whether someone can help me with the below.

Basically I have a table which contains numerous records (more than 10,000 records) and I need to replace a particular text with another text.

To give an idea I have attached an excel of the data I am working with. I need to replace all the word saying 'Purchase' with 'Prchs' but I need to keep the other text as is. Is there a shortcut for this. As I am typing Find: "Purchase*" and replace with "prchs" but when I do so he replace function is replacing all the other text not just purchase.

Would appreciate your kind help!

Find and replace.zip





Thanks

keibri

[Micron]

You are doing this in Access though?

copy table for experiment
create update query; for the field in question and in "update to" row enter Replace([fieldName],"Purchase","Prchs")
run it and check. Note - this will also affect any word that contains "purchase" as in PurchaseD, purchaseS

[rpeare]

don't wildcard the 'purchase'

you can use, in excel, the find and replace function just type PURCHASE in the FIND field and PRCHS (or whatever you want) int he REPLACE field. Then you can step through them one by one to make sure it's finding what you want and once you are just click replace all. NO reason to do anything fancy.

[Keibri]

Thanks for the reply guys!

Yeah I am doing it in Access. Tried the query and it worked great many thanks for all your help guys!