topic Re: Converting VBScript Label Expression to Python in Python Questions

Converting VBScript Label Expression to Python

sawillis96 — Wed, 05 Nov 2025 13:40:09 GMT

Hello All,

I am having trouble trying to convert VBScript label expressions to Python. I've tried running them through AI to help convert, but no luck. Is there a way within the ArcGIS Pro software to complete this?

Thanks!

Re: Converting VBScript Label Expression to Python

TonyAlmeida — Wed, 05 Nov 2025 15:38:27 GMT

It would help if you posted what you are trying to convert.

Re: Converting VBScript Label Expression to Python

HaydenWelch — Wed, 05 Nov 2025 22:06:35 GMT

Best way is to just manually port them over, but we can't help without the original script as Tony said

Re: Converting VBScript Label Expression to Python

sawillis96 — Thu, 06 Nov 2025 12:42:39 GMT

I was just curious if there was a method within ArcGIS Pro to automatically convert it. But here is the VBS code I'm working with.

Function FindLabel ( [F1], [Total_VOC_Jun_2017], [Total_VOC_Notes_Jun_2017], [Total_VOC_Oct_2017], [Total_VOC_Notes_Oct_2017], [Total_VOCs_2019_08], [Total_VOCs_Notes_2019_08], [Total_VOC_April_2022], [Total_VOC_Notes_April_2022])
FindLabel="<BOL><UND>" & [F1] & "</UND></BOL>"
FindLabel = FindLabel & vbNewLine & LabelBlockLineFormatter([Total_VOC_Notes_Jun_2017], [Total_VOC_Jun_2017])
FindLabel = FindLabel & vbNewLine & LabelBlockLineFormatter([Total_VOC_Notes_Oct_2017], [Total_VOC_Oct_2017])
FindLabel = FindLabel & vbNewLine & LabelBlockLineFormatter([Total_VOCs_Notes_2019_08], [Total_VOCs_2019_08])
FindLabel = FindLabel & vbNewLine & LabelBlockLineFormatter([Total_VOC_Notes_April_2022], [Total_VOC_April_2022])
End Function

Function LabelBlockLineFormatter([Descripter], [Value])
if([Descripter] = "Above Criteria") then
LabelBlockLineFormatter = "<CLR red = '255'>" & [Value] & "</CLR>"
elseif ([Value] = 0) then
LabelBlockLineFormatter = "ND"
elseif isnull([Value]) then
LabelBlockLineFormatter = "NS"
else
LabelBlockLineFormatter = [Value]
end if
End Function

Re: Converting VBScript Label Expression to Python

TonyAlmeida — Thu, 06 Nov 2025 15:46:51 GMT

Untested but try something like this,

python phrase,

def LabelBlockLineFormatter(Descripter, Value): if Descripter == "Above Criteria": return f"<CLR red='255'>{Value}</CLR>" elif Value == 0: return "ND" elif Value is None or Value == "<Null>": return "NS" else: return str(Value) def FindLabel(F1, Total_VOC_Jun_2017, Total_VOC_Notes_Jun_2017, Total_VOC_Oct_2017, Total_VOC_Notes_Oct_2017, Total_VOCs_2019_08, Total_VOCs_Notes_2019_08, Total_VOC_April_2022, Total_VOC_Notes_April_2022): label = f"<BOL><UND>{F1}</UND></BOL>" label += "\n" + LabelBlockLineFormatter(Total_VOC_Notes_Jun_2017, Total_VOC_Jun_2017) label += "\n" + LabelBlockLineFormatter(Total_VOC_Notes_Oct_2017, Total_VOC_Oct_2017) label += "\n" + LabelBlockLineFormatter(Total_VOCs_Notes_2019_08, Total_VOCs_2019_08) label += "\n" + LabelBlockLineFormatter(Total_VOC_Notes_April_2022, Total_VOC_April_2022) return label

expression line

FindLabel(!F1!, !Total_VOC_Jun_2017!, !Total_VOC_Notes_Jun_2017!, !Total_VOC_Oct_2017!, !Total_VOC_Notes_Oct_2017!, !Total_VOCs_2019_08!, !Total_VOCs_Notes_2019_08!, !Total_VOC_April_2022!, !Total_VOC_Notes_April_2022!)

Re: Converting VBScript Label Expression to Python

sawillis96 — Thu, 06 Nov 2025 16:05:40 GMT

Had to do some minor tweaks but this worked! Thank you so much!

Re: Converting VBScript Label Expression to Python

TonyAlmeida — Thu, 06 Nov 2025 16:36:31 GMT

Right on! Happy to help!