I need to replace part of a table value with another value. Example is that the field is a file location. It's current value is "Z:\Program Files\DataFile\thisisafile.txt". I need the new value to be "Z:\DataFile\thisisafile.txt".
In other words, only replacing the first part of the file location, keeping the file name the same.
I hope that makes sense. It's easier to think of than to describe. Thanks in advance for any help.