Insert a character into a field

KevinLaughlin — Mon, 05 Nov 2012 14:35:15 GMT

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

Re: Insert a character into a field

AnthonyGiles — Mon, 05 Nov 2012 15:37:32 GMT

You would want to use:

Right([fieldname],Len[fieldname] - 7)

Regards

Anthony

Re: Insert a character into a field

AnthonyGiles — Mon, 05 Nov 2012 15:39:10 GMT

Kevin

You would want to use:

Right([fieldname],Len[fieldname] - 7)

Regards

Anthony

topic Re: Insert a character into a field in Data Management Questions

Insert a character into a field

Re: Insert a character into a field

Re: Insert a character into a field