Find and Replace part of a field

[stephen.belyea]

I searched through the database to find out how to do this, but
couldn't really find a satisfactory answer (then again, I'm not the
brightest bulb in the box! :-D)

We recently relocated a number of files on our central server, and now
I need to change a large number of links in a database from "\\MyServer
\SharedStuff\ScannedStuff\FolderName" to "\\MyServer\SharedStuff
\Development\FolderName". Is there an easy to achieve this with a find/
replace or update query? If possible, I would like to retain the
"\FolderName" part of the equation, because if I don't then I would
have to manually go back through the tables and change each record
entry.

Thanks in advance!

 

[Amy Blankenship]

I searched through the database to find out how to do this, but
couldn't really find a satisfactory answer (then again, I'm not the
brightest bulb in the box! :-D)

We recently relocated a number of files on our central server, and now
I need to change a large number of links in a database from "\\MyServer
\SharedStuff\ScannedStuff\FolderName" to "\\MyServer\SharedStuff
\Development\FolderName". Is there an easy to achieve this with a find/
replace or update query? If possible, I would like to retain the
"\FolderName" part of the equation, because if I don't then I would
have to manually go back through the tables and change each record
entry.

Might be better to take this as an opportunity to remove the repetition in
your database so that you only have to change it once in future. But look
at the Replace function.

 

[stephen.belyea]

Might be better to take this as an opportunity to remove the repetition in
your database so that you only have to change it once in future. But look
at the Replace function.

It's the replace function I'm having trouble with - I'm not sure to
change only part of a string. The field in question is a hyperlink
field - how would I remove repetition from it in a scenario like this?

 

[stephen.belyea]

It's the replace function I'm having trouble with - I'm not sure to
change only part of a string. The field in question is a hyperlink
field - how would I remove repetition from it in a scenario like this?

Nevermind.. it was a simple matter of changing the combo box to "any
part of field" :-D