I am calculating values for a field (Score) based upon the names from another field (Modified). One name is "blaugh\nblaugh". Field Calculator keeps treating the name as having a new line command.
I have tried using Like, Right, Contains, etc but the Field calculator does not seem to be able to use those commands. I am stumped.
Ex1: elseif [Modified] = "blaugh\nblaugh" then Score =7
Ex2: elseif Right( [Modified], -6) = "blaugh" then Score =7
Ex3: elseif [Modified] LIKE "*nblaugh" then Score =7
I am using vb in ModelBuilder and ArcCatalog 10.3.1
Any help will be appreciated.
Solved! Go to Solution.
Darren,
Got it!
I took your code and modified it to:
elseif InStr( [Modified], nblaugh) then Score =7
Thank you very much for your help. I had been puzzling over that problem for some time.
Try:
elseif InStr([Modified], vbNewLine) then Score =7
It still doesn't work.
Field Calculator accepts the code but does not recognize any relevant records.
Darren,
Got it!
I took your code and modified it to:
elseif InStr( [Modified], nblaugh) then Score =7
Thank you very much for your help. I had been puzzling over that problem for some time.