Using Field Calculator vb to check for name with /n in the string

[TiffanySelvidge1]

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.

[DarrenWiens2]

Try:

elseif InStr([Modified], vbNewLine) then Score =7

[TiffanySelvidge1]

It still doesn't work.

Field Calculator accepts the code but does not recognize any relevant records.

[TiffanySelvidge1 · Accepted 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.