Parsing Text: Pathname
Is it possible to create a pathname for a container field by Parsing and concatenation? I have a table of records that contain text fields that are the pathname for pictures on an external drive.
(PC) Old Pathname - \\De07-HP\UniqueDB\Wood\syc\syc0062-a.jpg
(Mac) New Pathname - Mac07:/UniqueDB/Wood/syc/syc0062-a.jpg
I'm attempting to write a script to Parse the old pathname, removing the computer name and then concatenate it with the new computer name.