I'm not sure if this is the specific forum for this question, but here goes.
I need to insert a character into a string, specifically, " O" 7 characters into this string, for example:
P:\John\SEPTIC SYSTEM PERMITS DATABASE\SEPTIC SYSTEM PERMIT SCANS\LAKE\HICKS_BEVERLY_MARION.pdf
I understand it would be some combination of left, right, mid, etc., but how do you declare (?) a variable number of characters for a left/right function in field calculator. I understand using Left([NEW_HYPERLINK], 7)&" O"& to do this first part, but how do I return a variable number characters for the remainder of the string?
Thanks,
Kevin
