insert space into string with Field Calculator

[JasonFitzsimmons]

I am using ArcMap 10.7.1. This seems like it should be easy so maybe I am missing something.

I want to insert a space into a string between specific parts of the string using Field Calculator:

!FIELD! .replace("F'target", "F' target")

Neither 'F' or 'target' are at beginning or end of string, those characters are in the middle of a string.

I run the calculation, and nothing happens. I've tried to escape the single quote, but no difference. Do I need a wildcard tag at beginning and end of the substring?

I have tried this with VB and Python..I can change other string values in the same table.

[JayantaPoddar]

Could you share screenshot of the present values in the corresponding field of the attribute table? Do you have an apostrophe between F and target (e.g. F'target)?

[JasonFitzsimmons · Accepted solution]

I found the problem, the first single quote was " ‘ " instead of " ' "
Not sure how that got there but that was it