I cannot get the below to work with a LIKE variable within the If/Then statement. Is there something that I am missing?
Prelogic Script
dim y
If [Categories] LIKE '%Orange%' Then
y = "Medium"
Else y = [Categories]
End If
Status =
y
ArcGIS Desktop – Using If/Then Statement with LIKE in Field Calculator
arcgis-desktopfield-calculatorif statementvbscript
Related Solutions
If you're interested in a Python implementation, make sure you set your parser to "Python" and enter the below function in the Codeblock area. Then, all you have to do is call the function oddeven with the field name surrounded by "!".
def oddeven(n):
if n%2 ==0:
return "even"
else:
return "odd"
Here's a solution that should work. It also uses the UCase function that will convert your text to uppercase, so you don't have to check for all variants
dim output
if InStr(UCase( [Export_Output.std]), "LORAIN") > 0 then
output = 1
else
output = 0
end if
You'll also put "output" into the lower box
EDIT
Here's another test using joined data like in your original case.
Best Answer
There is no LIKE comparison operator in VB Script (see link).
You could use InStr to check if some search text appears somewhere in the input string:
InStr will return
0if the search text is not found, which will be interpreted as False in the condition statement.If you want to search some text explicitly in the begining of the input string, just check if the value returned from InStr is
1.If you want to search some text in the end of the input string, try Right function to extract part of the string and then do the comparison.