topic Re: Double Quote in Label Expression in Mapping Questions

Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 15:00:44 GMT

Hello,

Trying to get my label expression to work here. The problem is some of my table

records have a double quote in it (" symbol). I want to rename as such see example below:

(30" PVC Pipe Drain) and rename it to (30 inch)

I use the following vbScript - but get nowhere:

Function FindLabel ( [NAME] )

If Not IsNull([NAME]) Then

NewStr = Replace([NAME], "30'' PVC Pipe Drain", "30 inch")

FindLabel = NewStr

End If

End Function

--- also I tried python and get nowhere:

def FindLabel ( [NAME] 😞

S = [NAME]

S = S.replace( '30'' Drain, Vitreous Clay Pipe', '30 in')

return S

Re: Double Quote in Label Expression

Miguel_AngelBarrientos_Martíne — Thu, 18 Dec 2014 15:05:07 GMT

Hi:

Can you replace temporary the " for another sign for example ºº and then replace again?

Re: Double Quote in Label Expression

JamesFitzgerald — Thu, 18 Dec 2014 15:06:25 GMT

Hello M. Neer,

As a quick fix, you could export the attribute table to a databasefile.dbf and work on it from a standalone table to remove the quotation ("). then you could bring it back into arcGIS and join it to your shapefile.shp. Not as quick as code but it works!

Thanks,

James

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 15:06:48 GMT

Re: Double Quote in Label Expression

JamesFitzgerald — Sat, 11 Dec 2021 15:50:12 GMT

Hey,

Replace 'St' or 'St.' starting a new word at the end of the string with the word 'Street'.

Expression: update_street(!ADDRESS!) 
 
Expression Type: PYTHON_9.3 
 
Code Block: 
import re 
def update_street(street_name): 
     return re.sub(r"""\b(St|St.)\Z""", 
               'Street', street_name) 

Check ArcGIS Desktop under Regular Expressions.

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 15:13:08 GMT

Yes, that is a valid idea but I had forgotten to mention
earlier that

this is a source feature from our enterprise and I don't wish to

copy or manipulate the data in any way. My
intention is to re-label

on the fly dynamically.
Copying the data and pointing to copied source

is what I am attempting to avoid here.

Re: Double Quote in Label Expression

TedKowal — Sat, 11 Dec 2021 15:50:15 GMT

Using VBScript....

Replace( [Name],chr(34)," inch")

No advance script or block needed. --- Tested it with null values no issues..... if you simply want to replace " --> inch

Re reading you question If you want to shorten your label then you would need an advanced expression:

Function FindLabel ( [Name]   )
dblQuote = instr( [Name] ,chr(34))
if dblQuote > 0 then
   newStr = left( [Name] ,dblQuote - 1) & " inch"
else
   newStr = [Name]
end if
  FindLabel = newStr
End Function

Re: Double Quote in Label Expression

RichardFairhurst — Thu, 18 Dec 2014 15:39:04 GMT

To make all quotes turn into " inch" your VB Script label code should be:

Function FindLabel ( [NAME] )

If Not IsNull([NAME]) Then

NewStr = Replace([NAME], "''"", " inch")

FindLabel = NewStr

End If

End Function

This assumes no quote character in your data is a real quote character and always changes to inch. If that is true, you should not have to deal with the full field value in your features, just the quote character.

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 15:40:57 GMT

So, I attempted to reference my first posting above as an example (30" PVC Pipe Drain), in correlation with your posted py parser and it didn't appear to do anything.

Of course I may not be applying it correctly? It runs but does not change anything at this point.

import re

def FindLabel([NAME]):

return re.sub(r"""\b(30'' PVC Pipe Drain|30''Drain.)\Z""",

'30 in', [NAME])

Other helpful info maybe? Field Name = [NAME] and the text string in question 30'' PVC Pipe Drain

Re: Double Quote in Label Expression

JamesFitzgerald — Thu, 18 Dec 2014 15:54:13 GMT

M.Neer,

Another quick fix is to start an edit session, open up the attribute table, click on the table options and select the find and replace. Replace the (") with nothing (just leave blank). Save. I am still looking to do this through Python.

James

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 16:04:06 GMT

Excellent ! So very close. Need to drop all the text AFTER the word inch. When I attempt to

use LEFT() it reverts back to " double quote so I know we are close here.

Function FindLabel ( [NAME] )

If Not IsNull([NAME]) Then

NewStr = Replace([Name],chr(34)," inch")

FindLabel = NewStr

End If

End Function

Was (30" PVC Pipe Drain) and now is (30 inch PVC Pipe Drain30" PVC Pipe Drain) just need to drop text

PVC Pipe Drain. Perhaps compound it with LEFT()?

Re: Double Quote in Label Expression

JamesFitzgerald — Thu, 18 Dec 2014 16:09:38 GMT

M.Neer,

Sorry, but replace INCH not blank. I going to use your code. Excellent Job!!

James

Re: Double Quote in Label Expression

RichardFairhurst — Thu, 18 Dec 2014 16:11:39 GMT

You should have included that detail in your description of what you were trying to do, since dropping text is a completely different issue. So Try:

Function FindLabel ( [NAME] )

If Not IsNull([NAME]) Then

NewStr = [Name]

If Instr(NewStr, chr(34)) > 0 Then

NewStr = Left(NewStr, Instr(NewStr, chr(34)))

End If

NewStr = Replace(NewStr, chr(34), " inch")

FindLabel = NewStr

End If

End Function

Re: Double Quote in Label Expression

TedKowal — Thu, 18 Dec 2014 16:14:09 GMT

I edited my previous post to remove quote (really skipping over it ) and shorten the label

Re: Double Quote in Label Expression

RichardFairhurst — Thu, 18 Dec 2014 16:34:44 GMT

Caught that and fixed it in my post just before I saw your reply. Retry the code.

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 16:40:58 GMT

"Thank You" Ted & Richard. Both your suggestions have worked for me - hope they work for other GIS users. Very much appreciated!!

Re: Double Quote in Label Expression

JamesFitzgerald — Thu, 18 Dec 2014 16:56:33 GMT

Okay, You have hooked me. Now, I cannot get it to work. I used your code. Do you post the code in the code block? What do you enter into the "Name=" block? Do you have to create another field to populate?

Thanks

Re: Double Quote in Label Expression

mneer — Thu, 18 Dec 2014 17:03:13 GMT

No problem Richard please see snapshot below and here is the code that worked for me.

Function FindLabel ( [Name] )

dblQuote = instr( [Name] ,chr(34))

if dblQuote > 0 then

newStr = left( [Name] ,dblQuote - 1) & " inch"

else

newStr = [Name]

end if

FindLabel = newStr

End Function

Re: Double Quote in Label Expression

TedKowal — Sat, 11 Dec 2021 15:50:18 GMT

I am an old vb guy struggling to learn python..... for the challenge I attempted to get a python script to work as well.....

Bear in mind this is probably sloppy python but it works....

def FindLabel ([TestChar]):
  str = [TestChar]
  i = str.find(chr(34))
  if i > 0:
    newStr = str[:i] + " inch"
  else:
     newStr = str
  return newStr

Re: Double Quote in Label Expression

RichardFairhurst — Sat, 11 Dec 2021 15:50:20 GMT

The code has been written to work as an Advanced Label Expression, not as a field calculation. For a field calculation I would write it like:

Parser: VB Script

Use Codeblock: Checked

Pre-Logic Codeblock:

Output = [NAME]
dblQoute = instr(Output, chr(34))
if dblQuote > 0 Then  Output = Left(Output, dblQuote - 1) & " inch"

NAME= Output