I'm converting a VB Script Calculate Field expression to Arcade and can't get it right. The VB Script is:
Left([Control_Number__Control_Account___Control_Account_], 5) (Yes, it is a long field name)
The FarmCtrl field is set to the first 5 characters of field Control_Number__Control_Account___Control_Account_
I just can't get the Arcade syntax right, I've tried:
Left($Feature"Control_Number__Control_Account___Control_Account_", 5) but that doesn't work.
Solved! Go to Solution.
You have to encase the field name in brackets
Left($feature["Control_Number__Control_Account___Control_Account_"], 5)
feature
You have to encase the field name in brackets
Left($feature["Control_Number__Control_Account___Control_Account_"], 5)
feature
Thank you, that works. I'm learning Arcade now after years of VB Script and Python