How to insert a quotation mark through the Field Calculator of attribute table of a Shapefile?

Question

I have a shapefile of polylines with information of diameter. But the problem is that i didn't enter the inch sign(") with the values of diameter. What would be the solution that qutation mark would place along with diameter values?

Answer 1

As in the image below, you need to set a text field (DiamInch) equal to an integer field (Diam - ignore that I accidentally put OBJECTID instead) concatenated with a + sign to a double quote surrounded by two single quotes.

DiamInch = str(!Diam!) + '"'

Answer 2

2 methods.

1. You have to use 2 single quotes surrounded by double quotes.
   "''"
2. When you want to display your Inch mark on a label, use the following in the label expression.
   [myinchvaluefield] & "'' "
   EDIT: This works on a string field. (I guess I assumed you were attempting this on a string field to start with.)
   If you have a numeric field type it will not work. As PolyGeo shows you would need to create a new field.
   The easier solution (what I do) is to only show the inch mark on labels.

It might be good though to change the Alias of your field to describe the data clearer.