I currently have a field that has text for a hyperlink to a photo that I am trying to shorten. I only need the name of the file at the end but the length of the name varies by a few characters. The path before the name is always 59 characters. I have been trying to use "Right( [Overall_Ph], Len( [Overall_Ph]), -59 )" in the field calculator to remove the first 59 characters but it is returning an error.
Switch your Field Calculator parser to "Python" and try this:
This will output the rest of the field value, starting after the 59th character (Python indexes start at
Alternatively, if you wish to stick with VBScript Parser (I would recommend starting to use the Python parser) use the
mid() function instead of
Which will function in the same way as the Python one - output the value starting at the 60th character.