The start position for the SUBSTRING function is the position of the first dot +1 extra position shifted to the left (or right when the string is reversed). The length is the position of the first slash minus the position of the first dot minus one (to remove the slash itself). This ...